# 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

Tony

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

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

• Options

Thank you very much Toufong.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!