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 column find the results ...

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 as FALSE. depending ...

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 the column to pick a...

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 intervals.The functi...

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 sets of values.If t...

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 has more than one ref...

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(StartDate,Months) Exam...

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,FieldName,CriteriaRange) The...

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 ranking to be done. Synta...

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 your press F9 Syntax...

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(Numbertobedivided,divisor...

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: =PROPER(Text to convert) E...

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. Syntax: =Product(Number1...

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 Power() function and t...

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 BA will be considered...

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 tutorial for better u...

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 made anywhere on the W...

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 met, then the result...

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 this Function is, I...

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 need this function,...