If the result is negative, I would like the response to be 0
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 estimateinc. deductible)]@row  [Parts $ Amount]@row  [PDR $ Amount]@row) / 75 * 0.3 + [PDR $ Amount]@row / 1000
Thankyou in advance.
Tony
Best Answer

Hi, Tony.
Use the IF() function.
=IF((SUM([Total $ Amount (approved estimateinc. deductible)]@row  [Parts $ Amount]@row  [PDR $ Amount]@row) / 75 * 0.3 + [PDR $ Amount]@row / 1000) > 0, (SUM([Total $ Amount (approved estimateinc. 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

Hi, Tony.
Use the IF() function.
=IF((SUM([Total $ Amount (approved estimateinc. deductible)]@row  [Parts $ Amount]@row  [PDR $ Amount]@row) / 75 * 0.3 + [PDR $ Amount]@row / 1000) > 0, (SUM([Total $ Amount (approved estimateinc. 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,

Thank you very much Toufong.
Help Article Resources
Categories
Check out the Formula Handbook template!