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?