Feb 27 2019 05:41 PM
The formula in cell G12 is giving me a 0. I've tried everything and still can fix the formula. Any ideas?
Feb 27 2019 06:17 PM
Not sure if I interpreted you correctly
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
=IF($C12=0,0,$C12-$F$3)
if not can you explain a little clearer for me
Feb 27 2019 06:29 PM
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.
I might not be explaining myself rightly, English isn't my first language.
Feb 27 2019 08:50 PM
Hi
What are your expected results for G12, G13, G14, etc.?
Feb 28 2019 07:05 AM
Feb 28 2019 09:27 AM
I meant the real numbers.
For example:
G12 should be 444.
G13 should be 741.
G14 should be -4.