3D formulae

S

Steve

Hi

I've seen this mentioned a couple of times, but what is a 3D formula?
In idiotspeak?

Thanks

Steve
 
S

swatsp0p

Imagine a workbook with multiple sheets. If you picture the sheets
stacked one on top of the other and you wanted to add the values in
cell A1 of each sheet, that would be a three dimensional formula (as
you are not dealing with just the up and down/left and right on a
single sheet, but add the third dimension of levels above/below the
viewed sheet.

e.g.:

=sheet1!A1+sheet2!A1+sheet3!A1

of course this is a very simplistic example and the formulae can be
much more complex.

HTH

Bruce
 
Top