How many fictional tickets must be sold to cover a fixed cost? A spreadsheet can calculate revenue from a ticket quantity, but Goal Seek approaches the question backwards: choose the output that must be reached, identify the one input allowed to change, and let the spreadsheet search for an input producing that output. The important skill is interpreting the result, not merely pressing the command.
Ministry of Education V3.0 Reference 372 explains Goal Seek for the 2027 Singapore–Cambridge SEC G3 Computing K349 syllabus, Module 3.1.2. It teaches how to identify a formula cell, target value and changing cell; design a transparent one-input model; check mathematical feasibility and range constraints; interpret fractional and nonlinear solutions; and verify the result by substitution. All worked examples are invented and intended for classroom reasoning rather than real prices or financial advice.
This independent eduKateSG article is not an official MOE, SEAB or Cambridge publication. Consult the official 2027 K349 syllabus for the examinable function and feature list. Spreadsheet application menu names and solver implementation details may differ. Goal Seek is a one-variable what-if tool, not a guarantee that every economic or scientific decision has one feasible answer.
1. The official 2027 K349 Goal Seek requirement
Section 3.1.2 requires students to use the Goal Seek feature to determine the value needed in a cell so another cell reaches a specified target. The feature sits in Module 3, Spreadsheets, which is assessed in the laboratory paper along with programming. A correct workflow must identify the intended outcome and the allowed variable.
A learner should be able to explain the input-output dependency even without remembering the interface menu word for word. The feature is useful when a worksheet already calculates a result but the question instead asks what input would produce a particular result.
2. Forward calculation comes before working backwards
Suppose each fictional event ticket costs $15 and a student group sells 20. A simple revenue formula gives 15 × 20 = $300. This is a forward calculation: price and quantity are known and revenue is the output.
Now reverse the question: how many tickets at $15 would produce $450 revenue? Goal Seek can vary quantity until the revenue formula produces the specified target. The mathematical answer is 450 ÷ 15 = 30 tickets. Doing the arithmetic first gives an independent check.
3. Goal Seek needs a formula cell
The cell chosen as the result, often called the set cell, must contain a formula depending on the changing input. For example, if B2 contains price 15, B3 contains quantity 20, and B4 contains =B2*B3, then B4 is the result formula.
Trying to set a cell containing only an unrelated typed value does not express a useful input-output model. The dependency matters. Students should trace the references in the formula before invoking Goal Seek, confirming that changes in B3 actually affect B4.
4. Identify the target value separately
The target value is the number the output formula should reach. It is not another variable automatically added to the worksheet. In the ticket example, the target is 450, while the set cell is B4 and the changing cell is B3.
A frequent confusion is to enter 450 in the changing-cell field of the dialog. That would tell the tool to change the wrong quantity. The target is an output requirement; the changing cell is the adjustable input. State the three items aloud before clicking.
5. The changing cell should be an editable input
The changing cell is normally a value the workbook is allowed to adjust, not the final output formula itself. If a problem asks how many tickets are needed at a fixed price, the changing cell should be the quantity, not the fixed price.
If a different task asks what price would achieve a revenue target while quantity is fixed, the price could be the changing cell instead. One formula can support different what-if questions, but the permitted decision variable changes with the wording.
6. One target and one changing value
Basic Goal Seek changes one input to make one formula produce one target. A model with two prices and two quantities cannot automatically determine all four values uniquely from one output condition. The task must specify which single value can change and which other quantities remain fixed.
This is a limitation rather than an error. If a real decision involves multiple adjustable variables, budgets and competing objectives, a more specialised optimisation method may be necessary. For K349, focus on the named Goal Seek feature and verify the resulting value under the given assumptions.
7. A complete worked linear example
Let B2=200 represent a fictional fixed cost, B3=12 represent cost per item, B4 be the number of items, and B5 contain =B2+B3*B4. If the target total cost is 500, solve 200+12×B4=500. The answer B4=25 can be checked by substitution.
In Goal Seek, the set cell is B5, the target value is 500, and the changing cell is B4. The method is legitimate because B5 depends on B4. A student who chooses B3 as the changing cell would answer a different question: the cost per item required for the target.
8. Work from the spreadsheet formula, not the story alone
A task may describe a price, discount, quantity and fee. Rather than guessing which number Goal Seek should change, inspect the actual output formula. If the target cell excludes the delivery fee, achieving the target output may not mean that the total bill including fees is correct.
Document which costs or terms are present in the model. A result can be correct relative to an incomplete formula. The strongest student can state the model’s assumptions and point out which missing factors would change its suitability.
9. Verify by substitution
After Goal Seek returns an adjustable input, substitute that input into the original formula or inspect the recalculated result cell. If the target is 500 and the returned quantity is 25 in the linear example, the formula yields 200+12×25=500.
This check protects against a wrong target cell, stale references or a misunderstanding of the result. Record the input found, output calculated and target requested. If they differ beyond the appropriate precision, the task has not been fully verified.
10. Feasible inputs are not every real number
A spreadsheet may find a mathematical input that violates the real meaning of the variable. A quantity of 2.5 tickets or a negative number of participants is usually not feasible even if it makes the formula equal the target.
Goal Seek does not automatically enforce every domain constraint. The student must decide whether the input is a whole-number count, a nonnegative length or a value within a particular allowed range. It may be necessary to report that no exact feasible solution exists under the stated constraints.
11. A fractional answer can mean a threshold problem
Suppose the total is 100+12x and the target is 450. Algebra gives x=350/12, approximately 29.1667. A whole-number item count cannot equal that value exactly. If the task asks for the minimum number of items to reach at least the target, 30 is required, but that changes the requirement from equality to an inequality.
A student should not round automatically without reading the intended meaning. Rounding to 29 would produce 448, below 450. Rounding to 30 would produce 460, above it. Neither equals 450. Clearly distinguish exact target achievement from meeting or exceeding a threshold.
12. A mathematically possible input can violate a bound
Consider a cost model 20+10x, where x must be nonnegative. To achieve a target total of 5, algebra gives x=-1.5. That satisfies the bare linear formula but violates the nonnegative condition. The correct practical conclusion is that no allowed x reaches the target in that model.
The application may return a negative input; it cannot read every domain restriction from the prose question. The student must evaluate the result against any stated physical, financial or eligibility constraints. This step demonstrates understanding beyond the use of a dialog box.
13. Nonlinear models can have multiple answers
If the formula is x squared and the target is 25, both x=5 and x=-5 satisfy the mathematical equation. A numerical search may return one value depending on its starting point and algorithmic behaviour. The result should not be presented as the only mathematical solution without checking the model.
If the context restricts x to a nonnegative distance, only positive five is feasible. If negative values are allowed, both solutions require consideration. Goal Seek’s one returned value is not automatically proof of uniqueness.
14. A nonmonotonic model needs caution
In a simple linear expression increasing x always increases the output when its coefficient is positive. In a curved or piecewise model, changing x may first increase and then decrease the result, or encounter a discontinuity. A numerical search may struggle to converge or find a different root from another starting value.
The K349 student need not implement a numerical solver to understand this limitation. Inspect the relationship, try a few manual values, and ask whether the proposed solution is unique, feasible and consistent with the intended branch of the problem.
15. Display rounding is not a new exact solution
A workbook may display a returned changing-cell value rounded to two decimal places while storing more precision internally. A visible quantity of 29.17 is not the same as a mathematically exact 29.166666…, and the output formula may be correspondingly approximate.
For money and measurements, use the task’s precision requirement and verify the recalculated output. For indivisible items, an approximate fractional solver output is not automatically acceptable. Describe the difference between display format, numerical precision and real-world feasibility.
16. Goal Seek does not replace testing
A target cell can contain a wrong formula yet Goal Seek may find a value satisfying that wrong formula. The spreadsheet has performed the operation requested, but the model may not solve the actual problem. Independent checking starts with the formula and its assumptions.
A reliable workflow includes a normal input, an initial calculated result, a stated target, a permitted changing cell and an independent substitution test. If the result is unexpected, inspect those elements in that order before inventing an explanation for the solver.
17. Why this is different from ordinary what-if comparisons
Changing a cell manually from ten to twenty shows how the result responds to a chosen input. Goal Seek reverses the task: it seeks an input for a chosen output. Both rely on the same formula, but they answer different questions.
For teaching, first perform two forward calculations to establish the relationship, then use Goal Seek and verify the returned value. This prevents the feature becoming an opaque command whose answer cannot be reasoned about without a computer.
Fictional ticket worksheet
B2: 15 price per ticket
B3: 20 initial ticket quantity (changing cell)
B4: =B2*B3 calculated revenue (set cell)
Goal Seek request:
Set cell: B4
To value: 450
By changing: B3
Expected B3: 30
Verification: 15 * 30 = 450A twelve-stage Target–Input–Check protocol
This original teaching routine is not an official examination rubric. It makes Goal Seek a transparent numerical procedure rather than an unexplained interface action. The learner should be able to complete the first five stages using a paper description of the worksheet and the last stages by substitution and interpretation.
Stage 1 — Identify the outcome
Write a sentence describing which numerical result should reach the target, including its units.
Stage 2 — Locate the formula cell
Find the cell whose calculated value represents that outcome. Confirm it contains a formula rather than an unrelated typed number.
Stage 3 — Trace the dependency
Inspect the formula to see which input cells affect it. Sketch a small input-to-output arrow diagram if useful.
Stage 4 — Choose one permitted input
Identify the single cell allowed to change and distinguish it from inputs that must stay fixed.
Stage 5 — State the requested target
Record the desired output value in the correct units, without confusing it with the changing-cell input.
Stage 6 — Calculate an initial forward result
Use the current changing-cell value to evaluate the formula; confirm the worksheet produces the expected starting output.
Stage 7 — Predict a plausible answer
Solve simple linear models by hand or estimate an interval to understand what the tool should seek.
Stage 8 — Run the feature with three correct fields
Specify the set cell, target value and changing cell according to the spreadsheet application’s Goal Seek command.
Stage 9 — Read the returned input
Record the numeric value found rather than only the tool’s success message. Consider whether the answer is integral or fractional.
Stage 10 — Substitute it into the original formula
Compute the expected output using the returned input and compare it with the requested target.
Stage 11 — Check the input domain
Ask whether negative quantities, fractions, prices or measurements outside a stated range are allowed.
Stage 12 — Explain the conclusion and limitation
State what Goal Seek found, whether it meets the target within appropriate precision, and what assumptions prevent stronger claims.
Twelve original Goal Seek worked cases
Worked case 1 — The ticket-revenue target
Price is $15 and quantity is x, with revenue 15x. Setting the output to 450 gives x=30. The changing cell must contain quantity when price is fixed, and substitution yields 15×30=450.
Worked case 2 — A fixed and variable cost model
Total cost is 200+12x. Setting the total to 500 gives x=25. Check by computing 200+12×25=500. Changing the $200 fixed-cost cell would answer a different question.
Worked case 3 — A missing dependency
The selected output formula references B2 but not the chosen changing cell C2. Adjusting C2 cannot alter the set-cell value through that formula. The worksheet model must be corrected before seeking a solution.
Worked case 4 — A target pasted into the wrong field
A student enters 450 as the changing-cell address instead of as the target value. Goal Seek needs a cell address for the adjustable input, not a number masquerading as an address. Identify the three inputs to the command separately.
Worked case 5 — A whole-number ticket boundary
Revenue is 12x and the target is 350. The exact mathematical input is 350/12, about 29.17 tickets. If tickets must be whole numbers, the exact target cannot be reached with this formula.
Worked case 6 — Meeting at least a target
Using the previous revenue formula, a minimum of 30 tickets gives 360 and satisfies a requirement to raise at least 350. A quantity of 29 yields 348 and does not. This is an inequality decision after the exact-solution calculation.
Worked case 7 — An infeasible negative result
Total cost is 20+10x with x constrained to be nonnegative. A target of 5 yields x=-1.5 algebraically. Because the allowed domain excludes this input, no feasible solution exists under the stated model.
Worked case 8 — Two mathematical roots
With set-cell formula x² and target 25, both x=5 and x=-5 satisfy the equation. A single Goal Seek result does not prove that other solutions are absent.
Worked case 9 — Output without an input meaning
A workbook reports a number but the task never defines what the adjustable cell represents. The tool could produce a valid number, yet the student cannot interpret it as a permitted quantity or price. Define variables before searching.
Worked case 10 — An incorrectly copied formula
A model’s output references the wrong row after a formula was filled down. Goal Seek may satisfy that wrong formula perfectly. Check the referenced cells against the intended record before accepting the result.
Worked case 11 — Rounding conceals a residual
A changing cell displays 29.17 while internally holding about 29.1666667. The displayed value and exact mathematical solution differ. Verify the output to the precision required by the task rather than assuming two displayed decimal places prove exact equality.
Worked case 12 — A target already met
If the current formula output is already 450 and the requested target is 450, the existing input may be a valid solution. There is no obligation to change a value merely because the Goal Seek feature was invoked.
Twelve further Goal Seek scenarios and their limits
Worked case 13 — A fixed quantity but adjustable price
Thirty fictional tickets must produce $450. If quantity is fixed at thirty and price is the changing cell, Goal Seek should return price 15. Using quantity as the changing cell would violate the stated requirement.
Worked case 14 — A percentage formula
An invented worksheet calculates 0.8x after a fixed 20 per cent reduction. For target 80, the original amount x is 100. This result assumes the multiplier is genuinely 0.8 and is applied once, rather than a collection of stacked fees.
Worked case 15 — A quadratic with no real solution
A set cell calculates x²+1 and the target is zero. No real x can make this expression zero, because x² is nonnegative. A numerical solver cannot create a real solution that the model itself lacks.
Worked case 16 — A flat output region
Suppose an IF formula outputs zero for x below ten and one otherwise. A target of 0.5 is impossible for that stepwise model. Goal Seek may fail or return a candidate that does not reach the target, so verification matters.
Worked case 17 — A model with a minimum fee
Total = max(30, 5x), and the target is 30. Multiple x values in the appropriate range can yield the same target. A returned one-variable value is not automatically unique.
Worked case 18 — A changed input is below zero
A model of physical length returns -4 as an input. Even if the algebra is consistent, the negative length is not feasible. The domain constraint must be applied after the numerical calculation.
Worked case 19 — A required integer result
A project must use whole machines and Goal Seek returns 6.25. The answer may be mathematically exact for a continuous model but unsuitable for an integer decision. Rounding requires checking the resulting output and the requirement.
Worked case 20 — A target beyond equipment capacity
A hypothetical machine produces ten units per hour for up to five hours. A target of 80 requires eight hours by the formula, exceeding the stated capacity. The numerical result is not a feasible operating plan.
Worked case 21 — An incorrect absolute reference
The formula was meant to use fixed price in $B$2 but a copied reference shifts to B3. Goal Seek can satisfy the wrong dependency. Inspect the formula addresses before concluding that the target is achievable.
Worked case 22 — A sensitivity check after solving
A solution gives x=25. Evaluate the model at x=24 and x=26 to see how output changes near the target. This does not prove global uniqueness but can reveal whether the relationship is locally increasing or decreasing.
Worked case 23 — A scientific measurement with tolerance
The goal is a measured output near 50 rather than exactly 50. The appropriate tolerance comes from the problem and instrument accuracy. A solver value showing many decimal places does not imply that a real apparatus can achieve that precision.
Worked case 24 — A two-variable business plan
The task needs both price and sales quantity to change while maintaining an expense cap. Basic Goal Seek alone has only one changing cell and one output target. Additional assumptions or a different tool would be needed to solve the full decision.
Connected investigations: why the number must be interpreted
A complete fictional fundraising model
A fictional club charges $15 for a ticket and has a spreadsheet formula for revenue. The tutor first asks students to compute revenue at 10, 20 and 40 tickets, giving 150, 300 and 600. They can now reason that a target of 450 should require a quantity between 20 and 40, before using any software.
Next use Goal Seek to vary the ticket-count cell until the formula reaches 450. The result should be 30. Check the workbook formula, perform 15×30 by hand, and verify that exactly thirty is an allowed whole-number quantity. This exercise links forward calculation, inverse reasoning and practical feasibility.
A cost model with two kinds of variables
Suppose total cost is 200+12x. The constant 200 represents a fictional fixed commitment, the coefficient 12 is a per-unit cost, and x is quantity. Each part has a role. If the question asks how many units produce a cost of 500, only x is adjustable.
If the question instead asks what per-unit cost would reach 500 at fixed x=25, then the coefficient becomes the changing input and would equal 12. The same mathematical expression can support different what-if questions. A student must read the task rather than assume the rightmost number is always the one to change.
From exact equality to a practical threshold
A useful classroom comparison sets revenue to 350 when each item earns 12. The exact algebraic result is 29.1666 repeating, so no whole-number item count produces exactly 350. When the requirement is changed to at least 350, the smallest whole-number count is 30.
At 29 items, revenue is 348; at 30 it is 360. This distinction between equality and a threshold matters in scheduling, inventory and finance. Goal Seek answers the equality model, but the learner must decide how to interpret the result under the actual constraints.
A formula can be wrong while Goal Seek appears successful
Imagine the spreadsheet should include a delivery fee but the total formula omits it. Goal Seek can return a value producing the requested subtotal, and the output cell may display a pleasing exact match. Yet the total charge to the customer remains different.
The correct audit begins before solving: write the real-world requirement and compare it with the actual formula. After solving, check that every intended component is included and that the allowed input is the one that was changed. A tool can perform an operation correctly on an incomplete model.
Understanding solver output without false certainty
A numerical search may return a value with several decimal places. A display format might hide some of them, while the formula is calculated from the underlying stored value. For nonlinear functions or discontinuities, the result can also depend on starting assumptions and solver behaviour.
A student should therefore report an answer with appropriate precision, verify substitution, and avoid claims of global uniqueness or guaranteed feasibility. This is not a weakness of mathematics. It is the proper relationship between a model, a numerical method and the question that the model was intended to represent.
How a lab student can check their own work
Before opening the Goal Seek command, write the formula cell address, target number and changing cell address in a small planning table. Make a forward calculation using an easy input. After the feature runs, record what it changed and whether the set cell reached the target.
Finally check the changing cell’s allowed range, whole-number restriction and units. Save and reopen the specified workbook where permitted. A programme that solves an equation but leaves the deliverable in the wrong file or uses a prohibited input does not fully meet a lab task.
What parents and tutors should ask
A productive question is ‘Which cell contains the formula and what does it calculate?’ The next is ‘Which single value is permitted to change?’ Then ask whether the returned value is reasonable and how it could be verified without Goal Seek. These questions reveal conceptual understanding without doing the learner’s work.
For retrieval practice, vary one assumption at a time: increase the fixed cost, lower the target or restrict the input to whole numbers. The student should explain which part of the answer changes and why. The objective is independent reasoning, not memorising the location of a menu command.
Frequently asked questions
What does Goal Seek do?
It adjusts one selected input cell so a formula cell approaches a specified target result.
Which cell must contain a formula?
The set cell, whose calculated output should reach the target.
What is the changing cell?
The one permitted editable input that the feature can vary to influence the formula result.
Can Goal Seek change two inputs simultaneously?
Not in its basic one-variable form. Multiple-variable optimisation requires additional methods or assumptions.
Does a returned value always meet real-world constraints?
No. It may be fractional, negative or outside a required range, even when mathematically consistent.
Can a model have two solutions?
Yes. For example, x²=25 has two real solutions, and a numerical search may return only one.
Does success prove the formula was correct?
No. It shows the selected formula approached the target; the model itself still requires validation.
Should I round ticket counts?
Only according to the task. Exact equality and meeting a minimum target require different reasoning.
What if the result is approximate?
Check the difference from the target and use the precision and tolerance relevant to the problem.
What is the most useful final check?
Substitute the found input into the original formula and confirm both the numerical result and the allowed input domain.
Official K349 syllabus and connected references
Consult the official 2027 SEC G3 Computing K349 syllabus, especially 3.1.2. Continue with Reference 371 — Conditional Formatting, Reference 311 — Spreadsheet Methods, the MOE V3.0 library and the immutable Clementi teaching reference.
Editorial review: 29 October 2026, Singapore. All costs, quantities and targets are fictional teaching examples. The enduring skill is to identify the formula, target and changing input, then test whether the result is both mathematically correct and feasible.