Ever wondered what the most popular Microsoft Excel functions are? Well, direct from Microsoft, here are the most popular functions used in Excel. How many have you used?
#1 SUM function
The Microsoft Excel SUM function is used to add the values in cells.
#2 IF function
The Excel IF function is used to return one value if a condition is true and another value if it’s false.
#3 LOOKUP function
The LOOKUP function is used when you need to look in a single row or column and find a value from the same position in a second row or column.
#4 VLOOKUP function
The VLOOKUP function is used when you need to find things in a table or a range by row. This function is used like a key value lookup in a database table. The key value must always be to the left of the query data.
#5 MATCH function
The MATCH function is used to search for an item in a range of cells, and then return the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 7, and 38, then the formula =MATCH(7,A1:A3,0) returns the number 2, because 7 is the second item in the range.
#6 CHOOSE function
The CHOOSE function is used to select one of up to 254 values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index number.
#7 DATE function
The DATE function is used to return the sequential serial number that represents a particular date. This function is most useful in situations where the year, month, and day are supplied by formulas or cell references. For example, you might have a worksheet that contains dates in a format that Excel does not recognize, such as YYYYMMDD.
#8 DATEDIF function
The DATEDIF function is used to calculate the number of days, months, or years between two dates.
#9 DAYS function
The DAYS function is used to return the number of days between two dates.
#10 FIND, FINDB functions
THE FIND and FINDB functions locate one text string within a second text string. They return the number of the starting position of the first text string from the first character of the second text string.
#11 INDEX function
The INDEX function is used to return a value or the reference to a value from within a table or range.