Guía de usuario de Ulet

Primeros pasos con Ulet para Windows.

Recalculate a Formula by Changing an Input on Windows

A formula keeps a calculation connected to its inputs. The Riverside workbook includes an expense total and a Summary worksheet, so one input change provides a practical way to check recalculation.

For matching example data, use the Practice workbook section at the end of this guide.

Change the Paper amount

  1. Open a fresh working copy of the expense workbook.

  2. On Expenses, select B2 beside Paper.

  3. Replace 12 with 18 and press Enter.

  4. Check the Total cell, B7. It should now display 106.

English expense worksheet with Paper changed to 18 and the dependent total changed to 106

View screenshot at full size

An increase of 6 in one input increases the expense total by 6.

Check the linked summary

Select the Summary worksheet. Total expenses should also show 106. Practice subtotal, which adds only Paper and Pens, should show 26 because those inputs are now 18 and 8.

Select each result to inspect its formula in the formula bar. The formula should still refer to the intended expense cells; there is no need to replace the formula with the displayed result.

Save the updated inputs

Press Ctrl+S and reopen the saved working file. Check the changed input and both summary results again. This verifies the saved workbook as well as the calculation currently visible in the editor.

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.

Add a second worksheet named Summary. Enter Riverside budget in A1, Total expenses in A2, =SUM(Expenses!B2:B6) in B2, Practice subtotal in A3, =SUM(Expenses!B2:B3) in B3, Budget status in A4, and Draft in B4. The initial results are 100 and 20.

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

Tu suite ofimática todo en uno para las tareas diarias.

Ver funciones