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 zero until actual and temp are populated.
| HOURS | ||||
| SCHEDULED | RD ACTUAL | TEMP ACTUAL | WTD +/- | |
| 12/24/2023 | 174 | 155 | 8 | |
| 12/25/2023 | 174 | 163 | 8 | |
| 12/26/2023 | 172 | 0 | 0 | |
| 12/27/2023 | 172 | 0 | 0 | |
| 12/28/2023 | 174 | 0 | 0 | |
| 12/29/2023 | 0 | 0 | 0 | |
| 12/30/2023 | 0 | 0 | 0 | |
| 866 | 328 | 16 | ||
| PROJECTED HOURS | 1854.5 |
4 Replies
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)
