Forum Discussion
Help with +IF formula
Hi
I can't quite make this formula work. I want it to either calculate a sum following by multiplication, or if the sum is <+20 the return "0".
Any suggestions greatly welcomed
My previous column works well with this formula: =IF((G2-20>=20),(G2-20),"<20km") It returns "<20km" if the sum is less than 20
In the next column I want it to multiply the sum by 1.04 if it >=20, or return "0" if the sum is <20.
This is what I have - it isn't quite working! What am I missing?
=IF((G2-20>=20),((G2-20)*1.04),"0")
2 Replies
You haven't received any replies for almost a week, because you asked this in the "Lounge" forum instead of in the Excel forum.
In what way doesn't the formula work? Do you really mean that G2-20 must be greater than or equal to 20, i.e. that G2 must be greater than or equal to 40?
By the way, I'd use 0 instead of "0" in the formula. I assume that you want to return a number here, not a text value.
Try this: =IF(G2-20>=20, (G2-20)*1.04, 0)
