DPTutorials

This function rounds the number to its nearest Whole Number. Syntax: =INT(num) Example: The Table has some Numbers, and In the right...

This function tests a condition / Logic If the condition is met it is considered to be TRUE.If the condition is not met it is considered...

This function scans across the column headings at the top of a table to find a specified item.When the item is found, it then scans down...

This function compares a range of data against a list of intervals.The result shows how many items in the range of data fall between the...

This function uses two sets of values to predict a single value.The predicted value is based on the relationship between the two original...

This function looks for a specific letter in a word and gives the result as number of the position of the letter in a word. If the text...

This function will show the last day of the month which is a specified number of months before or after a given date. Syntax:...

This function examines a list of information and produces the largest value from a specified column. Syntax: =DMAX(DatabaseRange,FieldNam...

This Function calculates the position of a value in a list relative to the other values in the list. It can be very much used while...

This Function creates a random number between the given two numbers. The Number will change each time the worksheet recalculates or when...

This Function calculates the number of times a number can be divided by another number. It ignores any remainder. Syntax:...

This function converts the first letter of each word to uppercase, and all subsequent Letters are converted to lower case. Syntax:...

This Function multiples a group of numbers together. It is the same as using 2*3*4*5, which results the product of the four numbers....

This Function raises a number to a user specified power.It is same as using the 6 Operator, Such as 2^5, which results as 32. Both the...

This Function calculates the maximum number of permutations given a fixed number of items. The Internal order is Significant. so AB and...

This Function rounds a number up to the next highest odd number. Syntax: =ODD(number to be Rounded) Example: Here is the detailed video...

This Function Shows the Current Date And Time. The Result will be updated each time the Worksheet is opened and Every time an Entry is...

This function performs a test to see if the test fails. (A type of reverse logic). If the test fails, the result is TRUE. If the test is...

This function will calculate the number of working days between two dates. You can simply use the  subtraction method but the  Benefit of...

This function converts a numeric entry to its mathematical value.Anything which will not convert is shown as 0 zero.Excel does not really...