Excel Common Functions Checklist
FUNCTION NAME | FUNCTION SYNTAX | FUNCTION DESCRIPTION |
AVERAGE | =AVERAGE(C1:C4) | Find the average (mean) of a list of numbers. |
CONCATENATE | =CONCATENATE(B1,B2) | Joins contents of cells together |
CONVERT | =CONVERT(68, “F”, “C”) | Converts 68 degrees Fahrenheit to Celsius (20) |
COUNT | =COUNT(B4:B12) | Counts the number of cells which have a number in them |
COUNTBLANK | =COUNTBLANK(B7:B13) | Counts the number of empty cells |
COUNTIF | =COUNTIF(B2:B6,12) | Counts the number of cells which have a 12 in them |
DEC2BIN | =DEC2BIN(“19”) | Converts a decimal number 19 to binary |
HEX2OCT | =HEX2OCT(“3B4E”) | Converts hexadecimal 3B4E to octal |
IF | =IF(logical_test, [value_if_true], [value_if_false]) e.g. =IF(A2<=50,”PROMOTED”,”CHOPPED”) | Records PROMOTED if the number in cell A2 is less than or equal to 50 Otherwise, the function displays CHOPPED |
INT | =INT(B1) | Records the whole number part of a number e.g 3.15 becomes Integer 3 |
LARGE | =LARGE(B3:B13,2) | Gives the 2nd largest number |
LOG | =LOG(8, 2) | Returns the Logarithm of 8 with base 2 |
LOWER | =LOWER(A2) | Converts text string to Lower case |
MAX | =MAX(A2:A6) | Largest of the numbers in the range A2:A6 |
MEDIAN | =MEDIAN(A2:A6) | Median of all the numbers in the range A2:A6 |
MIN | =MIN(A2:A6) | Smallest of the numbers in the range A2:A6 |
MODE | =MODE(A2:A6) | Returns the commonest or most frequently occurring number in the range A2:A6 |
NOW | = NOW() | Returns the serial number of the current date and time |
OCT2BIN | =OCT2BIN(67) | Converts an octal number 67 to binary |
POWER | =POWER(2,4) | Returns 2 raised to the power of 4 i.e 2x2x2x2=16 |
PRODUCT | =PRODUCT(A2:A4) | Multiplies the numbers in cells A2 through A4. |
PROPER | =PROPER(A2) | Proper case of first string (this is a TITLE =This Is A Title) |
RANK | =RANK(NUMBER,REF,[ORDER]) e.g. =RANK(A3,A2:A6,1) | Gives the Rank (Position) of A3 out of the values in the range A2:A6, in ascending order |
ROMAN | =ROMAN(B2) | Converts the value in cell B2 to roman numerals |
ROUND | =ROUND(B3,2) | Rounds value in B3 to 2 decimal places |
ROUND | =ROUND(2.15, 1) | Rounds 2.15 to one decimal place |
SMALL | =SMALL(B3:B13,2) | Gives the 2nd smallest number |
SQRT | =SQRT(16) | Square root of 16 |
SUM | =SUM(C1:C4) | Adds a list of numbers |
TODAY | =TODAY() | Returns the current date. |
UPPER | =UPPER(A2) | Converts text to Upper Case (CAPITAL LETTERS) |