Formula returns 0

Question

The formula in cell G12 is giving me a 0. I've tried everything and still can fix the formula. Any ideas?&nbsp;https://1drv.ms/x/s!ArKKIl4JpMqRzW9qnM8bJMk87u66

scowan · Answer

Not sure if I interpreted you correctly&nbsp;&nbsp;If you are after a logical test to confirm there is a value in C12 and if not do nothing and if correct do the calc, then this will work&nbsp;=IF($C12=0,0,$C12-$F$3)&nbsp;&nbsp;if not can you explain a little clearer for me&nbsp;&nbsp;

darlingmesa · Answer

I'm sorry i did not explain myself clearly.

All i'm trying to do is a logical test using the IFS formula I'd like excel to If in C:C finds the number "2,446.96" to make it "600" and then if on G:G it finds a number like "600" to take away 600 from 2,446.96.