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?