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