| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
| Imputting an angle degree. Degree, minute, second | Excel Discussion (Misc queries) | |||
| Imputting an angle degree. Degree, minute, second | Excel Worksheet Functions | |||
| Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
| 3rd yr degree HELP!!! | Excel Discussion (Misc queries) | |||
Linear Mode
