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

  • JSanita
    JSanita ✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!