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# |