Forum Discussion
Formulas
I am looking for a formula to only populate WTD +/- result (scheduled-RD actual-temp actual when rd actual and temp actual are >0. The scheduled field will already be populated and needs to show z...
Substitute the correct cell addresses or field names.
=IF(OR(rd actual="", temp actual=""), 0, scheduled-rd actual-temp actual)
HansVogelaar Thanks. It partially worked. I need the WTD +/ field to remain at zero if RD actual and temp actual are zero. The scheduled column will be filled out in advance and the other two on a daily basis Only want the WTD +/- to update when all the columns have data >zero.
How about
=IF(AND(scheduled > 0, rd actual>0, temp actual>0), scheduled-rd actual-temp actual, 0)
- This looks good now. I appreciate the help.
