# 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!

• 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)

• 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!