15 FUNCTIONS YOU NEED TO KNOW USING EXCEL OFF BY HEART
USE AN EQUAL SIGN TO BEGIN THE FUNCTION
SPECIFY THE FUNCTION NAME
ENCLOSE ALL OF THE FUNCTION’S ARGUMENTS WITHIN PARENTHESES
USE A COMMA TO SEPARATE THE FUNCTION’S INDIVIDUAL ARGUMENTS
Combining text /values with & | =( & ) |
COUNTIF | =COUNTIF(range,argument) |
SUM | =SUM( ) |
ROUND | =ROUND(NUMBER, NUMBER OF DIGITS) |
AVERAGE | =AVERAGE( ) |
MAX | =MAX( ) |
MIN | =MIN( ) |
IF | =IF(logical_test,Value_if_True,Value_if_False) |
LEFT | =LEFT( ) |
MID | =MID( ) |
RIGHT | =RIGHT( ) |
PMT | =PMT(rate,nper,pv,fv,type) |
FV | =FV(rate,nper,pmt,pv,type) |
PV | =PV(rate,nper,pmt,fv,type) |
VLOOKUP | =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) |
No Comments