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

can anyone help?