Data Table

C

Carlo

Hi
I'm going around in circles!!

I have the following:
Tons Price/Ton
Sales 555.00 6,420.00
Prod 627.40 5,482.86
Contr 937.14

6,420.00 937.14
1000 937.1380002
1500 937.1380002
2000 937.1380002
2500 937.1380002
3000 937.1380002
3500 937.1380002
4000 937.1380002
4500 937.1380002
5000 937.1380002
5500 937.1380002
6000 937.1380002
6500 937.1380002
7000 937.1380002
7500 937.1380002
8000 937.1380002
8500 937.1380002
9000 937.1380002

The 937.14 in the table to the right of 6420 is a formula which is
6420-5482.86

The 6420 is a cell reference to the 6420 in the table above.

As you can see it gives me the same value for the contribution when I
try Data...Table....Column Input Cell where I reference the 6420 to
the left of 937.14

What am I doing wrong?
(I get a simple example to work but cannot seem to put it together for
this example)

Thanks
Carlob1
 

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

How to select one record of each from a column 2
Need help with a formula 2
two-variable data table question 9
Need help with a chart 4
how to solve the following in excel 1
complex chart 4
How do I lookup from a table 3
chart based on data ranges 1

Top