View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CameronM CameronM is offline
external usenet poster
 
Posts: 1
Default 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