Formulas

[James_B4124]

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

[#2]

@James_B4124 

Substitute the correct cell addresses or field names.

=IF(OR(rd actual="", temp actual=""), 0, scheduled-rd actual-temp actual)

[#3]

@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. 

[#4]

@James_B4124 

How about

=IF(AND(scheduled > 0, rd actual>0, temp actual>0), scheduled-rd actual-temp actual, 0)

[#5]

This looks good now. I appreciate the help.