referencing a value from a chart with 3 variables
 

Is it possible to have a value (that doesn't seem to have a simple
mathematical formula) appear in a cell from a chart that is dependent on 3
variables? More specifically, a pressure rise is obtained from a chart.
This value for the pressure rise depends on the specified model of heater
used, the specified cubic feet per meter, and the specified temperature rise.
I want to have the value of the pressure rise automatically appear when the
other three values are entered from drop down lists. Help me if you can.
Thanx

referencing a value from a chart with 3 variables
 

You will need to find a equation that fits the data. Begin by looking at
"trendline" in Help then come back with more questions
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"KP@RG" wrote in message
...
Is it possible to have a value (that doesn't seem to have a simple
mathematical formula) appear in a cell from a chart that is dependent on 3
variables? More specifically, a pressure rise is obtained from a chart.
This value for the pressure rise depends on the specified model of heater
used, the specified cubic feet per meter, and the specified temperature
rise.
I want to have the value of the pressure rise automatically appear when
the
other three values are entered from drop down lists. Help me if you can.
Thanx