In this column I want to return a 0 if the number is negative.
In this column I want to return a 0 if the number is negative and return the original number from the formula already in place if the number is positive. How do I nest the IF function into this formula to do that? Thanks!
Best Answer
-
If I'm understanding correctly;
=IF((EntireFormula)<0,0,(EntireFormula))
You just need to be careful to include your original formula in parenthesis ( ) in addition to the parenthesis for the If statement. (If formula results are less than zero, then return zero, otherwise return formula results)
Answers
-
If I'm understanding correctly;
=IF((EntireFormula)<0,0,(EntireFormula))
You just need to be careful to include your original formula in parenthesis ( ) in addition to the parenthesis for the If statement. (If formula results are less than zero, then return zero, otherwise return formula results)
-
That worked perfect!! Thanks!!
Help Article Resources
Categories
Check out the Formula Handbook template!