mightbe posted:

---

alright


here are my cells


High Temp:

Low Temp:


then i have to other cells


Growing Degree day high

Growing degree day low


now for growing degree day high, if the high temp is above 86, i want the growing degree day to be only 86. example i imput 95 into high temp and the data is then put into growing degree day high of 86 but not 95


now for growing degree day low, if the low temp is below 50, i want the growing degree day to be only 50. example i input 45 into low temp and the data is then put into growing degree day low of 50 instead of 45


also if no input is put in for a high temp or low temp the gdd temp will read 50


and finally temperatures that fall between 50 and 86 are recorded as is.


so example


High Temp: 0

Low Temp:0


GDD High: 50

GDD low: 50


High Temp:90

Low Temp:45


GDD High:86

GDD Low:50


example 2:


High Temp:75

Low Temp:55


GDD High: 75

GDD Low: 55

---

Rhodoman posted:

---

=If(AddressOfCellWithRealTempInput > 86, 86, AddressOfCellWithRealTempInput) or =If(<expression>, <value-if-true>, <value-if-false>


Repeat and fade.


Rho

---

mightbe posted:

---

thanks rho but is there also a way to include that if 0 temp is given for the day the gdd temp will be set at 50

---

Rhodoman posted:

---

thanks rho but is there also a way to include that if 0 temp is given for the day the gdd temp will be set at 50

---

Rhodoman posted:

---

Okie.


Say you never want it to be above 86 or below 50.


You put the REAL temperature into cell B15


In the cell you want to always be between 50 and 86, you put:


=If ( B15 > 86, 86, If( B15 < 50, 50, B15) )


One "If" formula nested inside the other.


Rho

---