Never seen excel formula question

[jfussell]

We had a consultant produce an excel spreadsheet to help drive our 5 year financial. In one of the cells he uses this formula

{=TABLE(,B7)}

What does this mean?

To give a bit more explaination, B7 = $1,568

Then where the above mentioned formula resides are the following info:

$1,568 (D4) | $1.27 (=D54)
$1,250 (D5) | $1.08 {=TABLE(,B7)}
$1,100 (D6) | $0.99 {=TABLE(,B7)}

This formula is something real new to me, so any help on this would be greatly appreciated. Thanks!

 

[Zathras]

You can't put that there directly. It is the result from creating a Data Table.

See menu Data/Table... and the help file.