Luke wrote on Thu, 30 Apr 2009 10:11:01 -0700:

Try this:

=(IF(A186,86,A1)+IF(B1<50,50,B1))/2-50
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"jdonnelly333" wrote:

All,

I would really love some help. I'm a novice at building
formulas, so I'm looking for some help making a formula for
calculating growing degree days. I've found others on the
web, but none that require base low and limit high
temperatures.

ColumnA is Hi temperatures, ColumnB is low temperatures.

Basic degree day calculations are figured by (A1+B1)/2-50.
What I need different is if A1 is greater than 86, I need it
to be calculated as 86. If B1 is less than 50, I need it
calculated as 50.

Can anyone help?

To the OP: this formula could give negative growing days. What does that
mean?
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not