Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up both row and column to give a third value
Hi All,
I have a spreadsheet similar to: The first column is the pressure, the first row is the specific gravity, and the rest of the table is the density at each pressure and specific gravity. 0 0.5 1.0 20 0 1.0 2.0 10 0 0.8 1.5 0 0 0.6 1.4 I wish to input a pressure and specific gravity and interpolate what the density will be. e.g. for 16 pressure and 0.7specific gravity, what will the density be? Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Find a row give me a column | Excel Discussion (Misc queries) | |||
Look up a value in one column and give a corresponding value | Excel Discussion (Misc queries) | |||
How can give the same name to a row or column in different sheets. | Excel Discussion (Misc queries) | |||
calculate which cells in column A will give me the total of column | Excel Worksheet Functions |