Check Formula Arguments with the Function Wizard in OpenOffice Calc

Use Insert → Function to build a calculation with each argument visible separately. The Function Wizard can show results and a formula structure, but it cannot decide whether you selected the right business data. A subtotal inside a selected range can produce a plausible, mathematically valid wrong answer.

Scope and complete practice data

The procedure follows the Apache OpenOffice 4.1 Calc Guide, using English desktop menu and function names. No native build, operating system, dialog interaction or save/reopen test was executed for this example. Expected results are independently calculated. The exercise uses ordinary scalar formulas, not array entry or a newer spreadsheet product’s dynamic-array interface.

In a blank sheet enter:

Cell	Content
A1	Core task minutes
B1	Minutes
A2	Sort
B2	7
A3	Label
B3	11
A4	Pack
B4	5
A5	Core subtotal
B5	=SUM(B2:B4)
C1	Alternative setup minutes
D1	Minutes
C2	Setup A
D2	2
C3	Setup B
D3	3
C4	Both setups total
D4	=SUM(D2:D3)

The core subtotal is 23 and both setups total 5. The first calculation below intentionally includes both setups; the second budgets only the longer alternative. Save a baseline as wizard-check-before.ods, then a working copy as wizard-check-practice.ods. Do not place a result inside an input range.

Build a two-range SUM

1. Select F2, an empty cell outside both input groups. Choose Insert → Function.
2. Locate SUM, using a function category to shorten the list if helpful. Double-click it to open its argument fields.
3. In the first argument field enter B2:B4, or use its Shrink control, select those cells in the sheet, then use the control again to return to the dialog. Verify the start and end cells, not just the highlighted color.
4. In the next argument field enter D2:D3. Leave the other argument fields empty.
5. Inspect the displayed result and formula. Expect 28, with the two ranges corresponding to =SUM(B2:B4;D2:D3). Additional absolute markers in selected references do not change this example’s intended cells.
6. Confirm with OK. Label E2 Core plus both setups and inspect F2’s formula in the input line.

The semicolon separates arguments in the documented syntax. A colon joins each rectangular range’s endpoints. Do not replace a range with a quoted string such as "B2:B4", and do not paste the entire formula into the first argument field. The wizard supplies the function structure; each field needs that argument’s content.

Catch a valid formula with the wrong range

In F3 type =SUM(B2:B5;D2:D3) and label E3 Intentional double count. It produces 51, not 28, because B5 repeats the 23-minute core subtotal. This is not necessarily a syntax error or a warning that the wizard can diagnose for you.

Compare the two formulas and explain the difference: 51 − 28 = 23. The correct range for the first task excludes B5. Keep F3 visibly labelled as an intentional error in the practice file, or clear it before using the file for anything else. Do not “fix” the output by subtracting an unexplained constant while leaving the wrong selection in place.

Inspect a nested alternative calculation

For a different question, budget core work plus the longer one of the two setup alternatives. In F5 enter =MAX(D2:D3) and label E5 Longer setup; expect 3. In F6 enter =SUM(B2:B4)+F5 and label E6 Separate check; expect 26.

Now select F4 and reopen Insert → Function. Choose SUM. Set the first argument to B2:B4 and the second to MAX(D2:D3), without an extra equals sign inside that argument. Inspect the formula =SUM(B2:B4;MAX(D2:D3)) and expected result 26. Use the Structure tab to inspect its parts: an outer SUM contains the core range and an inner MAX applied to the setup range. Confirm with OK and label E4 Core plus longer setup.

The helper cells make the same calculation easier to inspect. Agreement between F4 and F6 is a useful check, but it is not proof that MAX is the right planning assumption. If both setups are required, F2’s 28 is the relevant total instead. The wizard does not choose that requirement.

Run change tests and save the checked file

• Change D3 from 3 to 8. F2 should become 33; F4 and F6 should both become 31, with F5 8. Restore D3 to 3.
• Change B3 from 11 to 12. F2 should become 29, and F4 and F6 27. Restore B3 to 11.
• Confirm B5 23, D4 5, F2 28, F3 51, F4 26, F5 3 and F6 26 before saving.

Save the ODS, close and reopen it, then recheck the formulas and original results. ODS retains formulas; CSV is not a substitute for this multi-formula exercise. If numbers do not update, inspect automatic calculation and the actual input types before changing correct formulas. A leading apostrophe or text-formatted input may require correction; see formula text instead of results and calculation settings.

If the wizard result is unexpected, inspect every endpoint, argument and nested function. If the dialog shows a syntax problem, check parentheses and argument separators. For a larger dependency investigation, use Detective formula tracing. See SUM and MAX for the functions’ own reference material; this page concerns the entry-and-inspection workflow.

First-party references

Documentation checked 21 October 2026; no screenshot or native execution is claimed.

• Function Wizard: argument fields, range selection, results and Structure tab.
• Nested functions and helper-cell alternatives.
• Function structure, arguments and text versus cell references.