I have a problem to find the total with three argument

Copper Contributor

Ramya_Menon_Ramesh_0-1679674442561.png

If Column A is Change , then I want new total - Total Cost , but if New total is blank or NO then I want 0

 

2 Replies

@Ramya_Menon_Ramesh 

Untested.

=OR(NewTotal="No",NewTotal=0)*(NewTotal-TotalCost)

 

Sorry it is not working