goalSeek

Find the input value needed to achieve a target result (like Excel’s Goal Seek). Iteratively adjusts the control cell until the target cell reaches the desired value.

Parameter	Type		Description
write	object[]	required	Values to write before goal seeking
write[].cell	string	required	Cell reference
write[].value	string | number | boolean | null	required	Value to write before running goal seek
goalSeek	object	required	Goal seek parameters
goalSeek.targetCell	string	required	Cell containing the formula to reach target value
goalSeek.targetValue	number	required	Desired value for the target cell
goalSeek.controlCell	string	required	Cell to adjust to achieve the target
persist	boolean	optional	Whether to persist the solved control cell (and any pre-seek writes) to the workbook. Defaults to false: a pure calculation that reports the solution without changing the model.