In this column I want to return a 0 if the number is negative.
In this column I want to return a 0 if the number is negative and return the original number from the formula already in place if the number is positive. How do I nest the IF function into this formula to do that? Thanks!
Best Answer
-
If I'm understanding correctly;
=IF((EntireFormula)<0,0,(EntireFormula))
You just need to be careful to include your original formula in parenthesis ( ) in addition to the parenthesis for the If statement. (If formula results are less than zero, then return zero, otherwise return formula results)
Answers
-
If I'm understanding correctly;
=IF((EntireFormula)<0,0,(EntireFormula))
You just need to be careful to include your original formula in parenthesis ( ) in addition to the parenthesis for the If statement. (If formula results are less than zero, then return zero, otherwise return formula results)
-
That worked perfect!! Thanks!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!