Hi,

I've assumed a daya layout of

Col A Col B Col C Col D Col E
High Low Ave HDD CDD

So the Col D (HDD) formula is
=IF(AND(C2<65,C2<""),C2,"")

An in CDD
=IF(C2=65,C2,"")

Note an average of exactly 65 has to go in one or the other column and I've
guessed at CDD. Drag the formula down as required

Mike




"Lithium" wrote:

Excel 2000 Novice My first post.

I am trying to create a simple SS which calculates heating degree days and
cooling degree days.

Column headings are High, Low, Average, Heating Degree Days and Cooling
Degree Days.

If the average is under 65° (=65-AVG) then the number should be put in HDD
column, If over 65° (a negative number, or =AVG-65) the number should be put
in CDD column.

I'm not proficient enough to create a formula to put the number in the
appropriate column and leave the other column blank.

Can someone please give me some help with this?