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 previou...
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.