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!