Write Basic Arithmetic Formulas on Windows
Spreadsheet arithmetic begins with an equals sign. Use existing cell values as inputs so each calculation has a clear connection to its source.
For matching example data, use the Practice workbook section at the end of this guide.
Set up four calculations
Open a fresh working copy of the Riverside expense workbook. On Expenses, Paper in B2 is 12 and Pens in B3 is 8. Use the empty columns F and G for practice.
Enter Operation in F1 and Result in G1.
Label F2:F5 Addition, Subtraction, Multiplication, and Division.
In G2, enter =B2+B3.
In G3, enter =B2-B3.
In G4, enter =B2*B3.
In G5, enter =B2/B3. Commit each formula with Enter.

The same two inputs produce four different results according to the operator.
Check the results
The expected results are 20, 4, 96, and 1.5. Select a result to inspect its formula in the formula bar. Multiplication uses an asterisk and division uses a forward slash.
Check the denominator before dividing. A zero denominator cannot produce an ordinary numeric result.
Save your practice
Press Ctrl+S and reopen the same working file. Check both the formulas and their displayed results.
Practice workbook
To reproduce this example, start with a separate practice copy. On Ulet Home, choose Sheets. Rename the first worksheet Expenses and enter the following values in A1:E6. Enter amounts as numbers.
Item | Amount | Category | Owner | Status |
|---|---|---|---|---|
Paper | 12 | Supplies | Alex | Complete |
Pens | 8 | Supplies | Sam | Complete |
Desk lamp | 45 | Equipment | Jordan | Planned |
Notebook | 15 | Supplies | Alex | Planned |
Storage box | 20 | Equipment | Sam | In progress |
Enter Total in A7 and =SUM(B2:B6) in B7. The initial total is 100. Column widths, colors, and number formatting are presentation choices; the values and cell addresses are what the exercise depends on.
Press Ctrl+Shift+S to choose a practice folder and save as Riverside-Expense-Tracker.xlsx. Reopen this named copy before following the exercise above. Keep your original documents separate.

