DATA > TABLE -- 2 variable data tables?

E

efarhat

I have an excel s/s and several cells contain the same formula,
"{=TABLE(E15,E9)}". How can i find out what TABLE(E15,E9) is doing? I
think it's performing some type of calculation. Is it a table array?

any help is greatly appreciated.
 
T

TommySzalapski

TABLE is not a standard Excel worksheet function as far as I know. It
may be a user-defined function that one of your fellow employees
created.
If you are confident in Excel programming, check your add-ins.

Szalapski
 
D

Duke Carey

Your message header describes it perfectly - it's a 2 variable data table,
created through Data->Table. The first reference is the cell that the
values down the left side substitute for, the second reference is for the
values accross the top of the table
The formula at the intersection of those two ranges is reflected in the
table
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top