If the result is negative, I would like the response to be 0

Options

Good morning,

I'm looking for some help with a formula. This is the current formula I have, however would like to alter it so if the result is a negative, it would be 0 (rather than the negative number.

=SUM([Total $ Amount (approved estimate-inc. deductible)]@row - [Parts $ Amount]@row - [PDR $ Amount]@row) / 75 * 0.3 + [PDR $ Amount]@row / 1000

Thank-you in advance.

Tony

Best Answer

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭
    Answer ✓
    Options

    Hi, Tony.

    Use the IF() function.

    =IF((SUM([Total $ Amount (approved estimate-inc. deductible)]@row - [Parts $ Amount]@row - [PDR $ Amount]@row) / 75 * 0.3 + [PDR $ Amount]@row / 1000) > 0, (SUM([Total $ Amount (approved estimate-inc. deductible)]@row - [Parts $ Amount]@row - [PDR $ Amount]@row) / 75 * 0.3 + [PDR $ Amount]@row / 1000),0)

    IF( Result_Of_Formula > 0 , Result_of_Formula, 0)

    You can find documentation for additional Smartsheet functions here,


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!