Problem with my formula which require variable extract from steam table.

i m now doing my final year project n the formula has a variable from steam table. different temperature will be assign to different pressure.

let say 20 degree C - 10kPa
25 degree C - 18kpa

now if i key in 22 degree C in the input sheet, the formula in output sheet has to automatically extract the pressure from the interpolation between 10 n 18kPa n finally calculate the output i desire.

anybody can help me wit this? thanks..

Try to use this formula:
=(<temperature>-20)*8/5+10

Regards,
Antonio

Originally Posted by antoka05

Try to use this formula:
=(<temperature>-20)*8/5+10

Regards,
Antonio

is the formula just for interpolation?
my main problem is how to automatically extract the pressure and substitute inside my formula. coz the input will be temp. but the one substitute inside the formula would be the pressure..thx.