what function is this ...?

[buccaneer]

hi all,

I've got a worksheet example for Kriging interpolation. there is one function I don't understand.

{=TABLE(G4,H4)}


on 16x10 array.

when I tried to evaluate the function, it refers to neither "G4" nor "H4".
instead it refers to another cell and because it is array function the reference cell remains the same for the whole array.

the result shows different values on each cell in the 16x10 array( I think it looks like a range number since it is about interpolation).

any information will be appreciated.

 

[GlennUK]

Have a look here:

http://www.ozgrid.com/Excel/data-tables.htm

Data Tables are a very powerful "What-If" feature of Excel ... and that's what you are looking at there.

 

[buccaneer]

Thnx Glenn. that's very helpful.

Have a look here:

http://www.ozgrid.com/Excel/data-tables.htm

Data Tables are a very powerful "What-If" feature of Excel ... and that's what you are looking at there.