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

Options

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 ✓
    Options

    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

  • JSanita
    JSanita ✭✭✭✭
    Answer ✓
    Options

    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
    Andre O ✭✭✭
    Options

    That worked perfect!! Thanks!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!