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

Tony DeSantis

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

Toufong Vang

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,

https://help.smartsheet.com/functions

Toufong Vang

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,

https://help.smartsheet.com/functions

Tony DeSantis

Thank you very much Toufong.