Nick Gardner wrote:
Steve

As you seem to be in the 'know' on Excel issues, I would like to get Excel
to calculate how much a given reading is below or above the long-term
average. Like this example:

Mean Min LTA
7.0 6.5 +0.5
5.0 6.5 -1.5

If you get my drift....cheers.
_______________
Nick G
Otter Valley, Devon
83 m amsl
http://www.ottervalley.co.uk



Easy !
Let A1 = 7.0
Let B1 = 6.5
In cell C1 the formula would be =A1-B1


--
Joe Egginton
Wolverhampton
175m asl