Another way to tinker with
Let's quickly set up a one variable data table
Try this in the *same* sheet:
Put in say, D1: =A3
(just a simple link to the output cell of interest)
List a set of possible values for A1, say: 1,2,3 ... 10
down in C2:C11
Select C1
11
Click Data > Table
In the Table dialog:
Leave the "Row input cell" empty
Input for :Column input cell" : A1
Click OK
In C1
11 will appear:
7**
1 7
2 14
3 21
4 28
5 35 < read-off the value in col C (for 35 in col D)
6 42
7 49
8 56
9 63
10 70
**It's usual to mask the link cell D1 by
formatting the font in say, white
to blend-in with the fill color
The output range D2
11 will compute
the various results (for A3)
depending on the possible inputs (for A1) listed in C2:C11
So we could just scroll down and read-off the value in col C,
i.e. "5" which computes to the target value of "35" in col D
And if needed (supposing there isn't any value resembling our target value
of 35 in the output range in D2
11) we could just change the listed values
in C2:C11 to yet other values (e.g.: try putting in C2:C11 : 11,12,13 ...
20) to experiment further. The table will recalc accordingly to give us the
new results in D2
11.
Extend to suit ..
Note: Albeit the TABLE formula, {=TABLE(,A1)} which will appear in every
cell in the output range D2
11, looks very much like an array formula, it
cannot just be entered as such. The construct must be done / invoked via the
Data > Table menu.
