Hi
Anyone know how to do this?
I have a webpage that has to calculate Degree Days for fuel usage within the home. It has a field called strdegday which is populated from a calculation of min and max temperature divided by 2.
so max 19 + min 13 = 32 / 2 = 16
We work from a normal of 19 for the degrees round here, so 19-16 leaves me 3 as the degree day.
Phew hope that makes sense.
But i need to add a factor for Hot Water usage and that's where im stumped.
With the field stdegday now populated with the figure 3 I need to do an IF calculation on it.
I need to know:
if strdegday= 0 to 6 then write 0
or if strdegday=7 to 10 then write 1
11 to 16=2 and 17 and over write 3
If only it was as easy as above !
It's to build in a hot water factor so if Degreeday was 9 then there would be a plus 1 hot water factor, leaving me finally with a total degree day of 10.
Any pointers in the right direction would be really appreciated.
Regards