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:

---

Rhodoman posted:

---

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

Repeat and fade.


Rho

---

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:

---

mightbe posted:

---

[quote=Rhodoman or =If(<expression>, <value-if-true>, <value-if-false>)

Repeat and fade.


Rho

---

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

---