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 estimate-inc. deductible)]@row - [Parts $ Amount]@row - [PDR $ Amount]@row) / 75 * 0.3 + [PDR $ Amount]@row / 1000
Thank-you in advance.
Tony
Best Answer
-
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
-
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,
-
Thank you very much Toufong.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!