Ulet-gebruikershandleiding

Aan de slag met Ulet voor {platform}.

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.

  1. Enter Operation in F1 and Result in G1.

  2. Label F2:F5 Addition, Subtraction, Multiplication, and Division.

  3. In G2, enter =B2+B3.

  4. In G3, enter =B2-B3.

  5. In G4, enter =B2*B3.

  6. In G5, enter =B2/B3. Commit each formula with Enter.

English worksheet with four labeled arithmetic calculations and results 20, 4, 96, and 1.5

View screenshot at full size

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.

Ulet

Je complete kantoorpakket voor het dagelijkse werk.

Functies bekijken