Spreadsheet Formulas

Spreadsheet Formula Syntax. Select a cell. From the Format Menu (or right-mouse click on spreadsheet), Click on Cell Type.  In order to have a formula in a cell it must be of type Integer or Currency/Float.  Click on one of these.  Currency/Float allows a cell to have a decimal point where you decide how many places to the right of the decimal to show and whether or not to display the dollar sign or a comma denoting a thousand separator. Remember: Formulas must begin with an equal sign (=), such a =A1+A2.

Operator Description Literal / Literal Cell Ref / Literal Cell Ref / Cell Ref
+ Addition 2 + 2 A1 + 2 A1 + B2
- Subtraction 4 - 2 A1 - 2 A1 - B2
^ Raise to the power 2 ^ 2 A1 ^ 2 A1 ^ B2
* Multiplication 2 * 2 A1 * 2 A1 * B2
/ Division 2 / 2 A1 / 2 A1 / B2
& Logical AND 2 & 2 A1 & 2 A1 & B2
| Logical OR 2 | 2 A1 | 2 A1 | B2
: Range summation   A1:A10 * 2 A1: B2
# Wild card   A# * 2 A# * B#