hi
thanks for the feed back. glad to help.
i do how ever need a spell check/grammer secretary. or take a remedial
typing course.
sigh.

Regards
FSt1


"Lithium" wrote:

FSt1: Thank you for the quick response. Your formulas work.

Mike_H: Your formulas gave me the AVG in the HDD and CDD columns--maybe
something I didn't do right.

"FSt1" wrote:

hi
first, formula return values to the cell in which the reside. they cann't
put values into other cells.
so, will will need a fomurla for each calculation , one in the HDD column
and one in the CDD columns
lets say that high is column A, low in column B, Average is column C, HDD is
column D and CDD is column E.
assuming that the AVG is in column C, in D1 enter...
=if(C2<65,65-C2,"")
or if C2(AVG) is less than 65 then 65-AVG else leave it blank.
in E2 enter...
=if(C265,C2-65,"")
or if C2 is greater than 65 the AVG-65 esle leave it blank.

regards
FSt1