ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula for degree days (https://www.excelbanter.com/excel-worksheet-functions/181297-formula-degree-days.html)

JohnF

Formula for degree days
 
what is the formula in working with degree days where you want to say
subtract degree day that was above zero degrees but will add to a number when
the deegree day is below zero such as -10 degrees.
Thanks
--
JohnF

Pete_UK

Formula for degree days
 
Taking this formula:

=Temperature - Degree_day

then if Degree_day is positive (above zero) it will be subtracted, and
if it is negative it will be added.

Hope this helps.

Pete

On Mar 26, 12:17*am, JohnF wrote:
what is the formula in working with degree days where you want to say
subtract degree day that was above zero degrees but will add to a number when
the deegree day is below zero such as -10 degrees.
Thanks
--
JohnF




All times are GMT +1. The time now is 04:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com