Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Formulas

Copper Contributor

 

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 
 SCHEDULEDRD ACTUALTEMP ACTUALWTD +/-
12/24/20231741558 
12/25/20231741638 
12/26/202317200 
12/27/202317200 
12/28/202317400 
12/29/2023000 
12/30/2023000 
 86632816 
PROJECTED HOURS1854.5   
4 Replies

@James_B4124 

Substitute the correct cell addresses or field names.

 

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

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

@James_B4124 

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.