how to use data table

S

steve

I've used it in previous versions, but not in 2007. I have 2 input cells
that I would like to vary. I assume the top and left side of highlighted
area will be the values for the respective inputs. However, how do I pick
the field to see the output results? There is no help on this function in
excel 2007. Thanks
 
R

Roger Govier

Hi Steve

Search for What If analysis
5th item down is Calculate multiple results by using a data 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

Similar Threads

Page numbering with Merged Document and IF statements 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Using Styles In An Outline 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
countifs Function not giving desired result with date criteria 2
Active Calendar 1
VLOOKUP/HLOOKUP Query 0
Table Preferred width is changed when pasting 1

Top