Function Example Purpose
SUM =SUM(A1:A5) Adds values
AVERAGE =AVERAGE(A1:A5) Average
MAX =MAX(A1:A5) Largest
MIN =MIN(A1:A5) Smallest
COUNT =COUNT(A1:A5) Count numbers
COUNTA =COUNTA(A1:A5) Count non-empty
COUNTBLANK =COUNTBLANK(A1:A5) Count blanks
IF =IF(A1>=35,"Pass","Fail") Condition
AND =AND(A1>0,B1>0) All true
OR =OR(A1>0,B1>0) Any true
NOT =NOT(A1>0) Reverse
SUMIF =SUMIF(A1:A5,">10",B1:B5) Conditional sum
COUNTIF =COUNTIF(A1:A5,">10") Conditional count
AVERAGEIF =AVERAGEIF(A1:A5,">10") Conditional avg
ROUND =ROUND(A1,2) Round
ROUNDUP =ROUNDUP(A1,1) Round up
ROUNDDOWN =ROUNDDOWN(A1,1) Round down
INT =INT(A1) Integer
ABS =ABS(A1) Absolute
SQRT =SQRT(A1) Square root
POWER =POWER(A1,2) Power
MOD =MOD(A1,2) Remainder
TODAY =TODAY() Date
NOW =NOW() Date/time
DAY =DAY(A1) Day
MONTH =MONTH(A1) Month
YEAR =YEAR(A1) Year
UPPER =UPPER(A1) Upper
LOWER =LOWER(A1) Lower
PROPER =PROPER(A1) Proper
LEN =LEN(A1) Length
LEFT =LEFT(A1,3) Left
RIGHT =RIGHT(A1,3) Right
MID =MID(A1,2,3) Middle
TRIM =TRIM(A1) Remove spaces
CONCAT =CONCAT(A1,B1) Join
TEXT =TEXT(A1,"0.00") Format
VALUE =VALUE(A1) Text to number
FIND =FIND("a",A1) Find
REPLACE =REPLACE(A1,2,3,"X") Replace
SUBSTITUTE =SUBSTITUTE(A1,"a","b") Substitute
RAND =RAND() Random
RANDBETWEEN =RANDBETWEEN(1,100) Random range
VLOOKUP =VLOOKUP(A2,A:C,2,FALSE) Lookup
HLOOKUP =HLOOKUP(A1,A1:E5,2,FALSE) Horizontal lookup
INDEX =INDEX(A1:A5,3) Indexed value
MATCH =MATCH(50,A1:A5,0) Position
ISNUMBER =ISNUMBER(A1) Is number
ISTEXT =ISTEXT(A1) Is text
ISBLANK =ISBLANK(A1) Is blank