Start every formula with =
Use cell references like A1, B2, C3
Use operators like +, -, *, /
Use parentheses to control calculation order
Use functions like SUM, AVERAGE, COUNT, IF
Example: =A1+B1
Example: =SUM(A1:A10)
Example: =IF(A1>10,”Yes”,”No”)
Press Enter to calculate the formula
Use the fill handle to copy formulas
Use relative references for copied formulas
Use absolute references with $ signs, like $A$1
Use mixed references like $A1 or A$1
Check formulas for errors like #VALUE!, #DIV/0!, and #NAME?
Use the formula bar to edit formulas
Use AutoSum for quick totals
Use named ranges for easier formulas