EXCEL FORMULAS When you are building formulas, use the following symbols: + * / for addition for subtraction for multiplication for division
ADDITION: =A2+A3 Adds numbers in particular cells =SUM(A2:A5) Adds numbers in a range _____________________________________________________________ SUBTRACTION: =B2-B3 Subtracts numbers in particular cells
_____________________________________________________________ MULTIPLICATION: =C2*C3 Multiplies the numbers in the two cells
DIVISION: =D2/D3 Divides the numbers in the two cells
AVERAGE: =AVERAGE (A4:A10) Calculates the average of the data in the cells from A4 through A10