In this column I want to return a 0 if the number is negative.

Andre O

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!

JSanita

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)

JSanita

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)

Andre O

That worked perfect!! Thanks!!