DpMay 1, 20181 min"INT" Function In ExcelThis function rounds the number to its nearest Whole Number. Syntax: =INT(num) Example: The Table has some Numbers, and In the right colu...

DpMay 1, 20181 min"IF" Function In ExcelThis 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 ...

DpMay 1, 20181 min"HLOOKUP" Function In ExcelThis 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 ...

DpMay 1, 20181 min"FREQUENCY" Function In ExcelThis 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 ...

DpMay 1, 20181 min"FORECAST" Function In ExcelThis function uses two sets of values to predict a single value.The predicted value is based on the relationship between the two original...

DpMay 1, 20181 min"FIND" Function In ExcelThis 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 h...

DpMay 1, 20181 min"EOMONTH" Function In ExcelThis function will show the last day of the month which is a specified number of months before or after a given date. Syntax: =EOMONTH(St...

DpMay 1, 20181 min"DMAX" Function In ExcelThis function examines a list of information and produces the largest value from a specified column. Syntax: =DMAX(DatabaseRange,FieldNam...

DpApr 30, 20181 min"RANK" Function In ExcelThis 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 ranki...

DpApr 29, 20181 min"RAND" Function In ExcelThis Function creates a random number between the given two numbers. The Number will change each time the worksheet recalculates or when ...

DpApr 29, 20181 min"QUOTIENT" Function In ExcelThis Function calculates the number of times a number can be divided by another number. It ignores any remainder. Syntax: =QUOTIENT(Numbe...

DpApr 29, 20181 min"PROPER" Function In ExcelThis function converts the first letter of each word to uppercase, and all subsequent Letters are converted to lower case. Syntax: =PROPE...

DpApr 29, 20181 min"PRODUCT" Function In ExcelThis 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. Synt...

DpApr 29, 20181 min"POWER" Function In ExcelThis 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 Pow...

DpApr 29, 20181 min"PERMUT" Function In ExcelThis Function calculates the maximum number of permutations given a fixed number of items. The Internal order is Significant. so AB and B...

DpApr 29, 20181 min"ODD" Function In ExcelThis Function rounds a number up to the next highest odd number. Syntax: =ODD(number to be Rounded) Example: Here is the detailed video t...

DpApr 29, 20181 min"NOW" Function In ExcelThis Function Shows the Current Date And Time. The Result will be updated each time the Worksheet is opened and Every time an Entry is ma...

DpApr 29, 20181 min"NOT" Function In ExcelThis 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 ...

DpApr 29, 20181 min"NETWORKDAYS" Function In ExcelThis function will calculate the number of working days between two dates. You can simply use the subtraction method but the Benefit of...

DpApr 29, 20181 min"N" Function In ExcelThis function converts a numeric entry to its mathematical value.Anything which will not convert is shown as 0 zero.Excel does not really...