VLOOKUP should do the trick

Define your table of Temps and SGs. I called mine "TempSGtable"

Temp S
22 0.997
23 0.997
24 0.997
25 0.997

The following function will return SG values for Temp values placed in cell A1

VLOOKUP(A1,TempSGtable,2,0

Hope this helps

Kevi

----- Lee Parker wrote: ----

I wish to calculate the accuracy and precision of laboratory pipettes
and use the specific gravity of water. However, the specific gravit
of water changes with temperature and this needs to be included in th
equation. I would like to have box in the spreadsheet for th
temperature. I would then like to relate this value to som
pre-determined constants = eg at 22oC specific gravity = 0.9978, a
23oC specific gravity equals 0.9976 etc. Therefore, the calculatio
would need to check what value of temperature is entered
cross-reference the specific gravity value and then use the value i
the equation

can anyone help