what is {=TABLE(D11,D10)} in the formula? i found it in a protected worksheet

there is a table where the formula show this.

.. {=TABLE(D11,D10)}
It's a formula (looks like an array formula)
which has to be set-up/invoked via the Data Table menu
where D11, D10 are the row and column inputs
[Check up: "data table" in Help]

Perhaps a simple example?

Suppose we have an output cell of interest in D12
which depends on 2 upstream, precedent cells: D10 and D11

Let's say we have in D12: =D10*2+D11*5
(just a simple formula, but formula could be of any
complexity, as long as it depends on D10 and D11
upstream)

To see how the value in D12 would vary depending
on a range of possible inputs in D10 and D11
("what-ifs")
we could set up a 2 var data table:

Put in say, F12: =D12
(a simple link to the output cell of interest)

List across in G12:K12 the sample values: 1,2,3,4,5
(These are for the row input cell: D10)

List down in F13:F17 the sample values: 1,2,3,4,5
(For the col input cell: D11)

Select F12:K17

Click Data Table

In the dialog, put for:
Row input cell: D10
Column input cell: D11
Click OK

You'll get the grid below which computes
in the intersecting range: G13:K17,
the calculated values of the output cell D12
based on the listed values of the 2 precedents, i.e.:
D10 (values listed in the "row": G12:K12), and
D11 (values listed in the "col": F13:F17)

120 1 2 3 4 5
1 7 9 11 13 15
2 12 14 16 18 20
3 17 19 21 23 25
4 22 24 26 28 30
5 27 29 31 33 35

(It's usual to mask the link cell F12 by
formatting the font in say, white
to blend-in with the fill color)

You could change the listed values in
either G12:K12 or F13:F17
and the table will recalc accordingly

Extend to suit ..

Note:
-------
The formula: {=TABLE(D10,D11)} will appear in G13:K17
Albeit it looks like an array formula, it cannot just
be entered as such. The construct must be done / invoked
via the Data Table steps outlined
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Leung" wrote in message
...
what is {=TABLE(D11,D10)} in the formula? i found it in a protected
worksheet

there is a table where the formula show this.