Mar 24 2023 09:15 AM
If Column A is Change , then I want new total - Total Cost , but if New total is blank or NO then I want 0
Mar 24 2023 09:33 AM
@Ramya_Menon_Ramesh
Untested.
=OR(NewTotal="No",NewTotal=0)*(NewTotal-TotalCost)
Mar 24 2023 09:37 AM