Generating an "if greater than zero, then this" "if less than zero, then that" formula
Below is the formula that I'm trying to use.
=IF([Days Behind]@row <=0,“$0.00”, [Days Behind]@row >0, [Days Behind]@row * 257
Essentially I want the cell to read as "0.00" if the days behind column is 0 or below. If the days behind column is 1 or above I would like it to read as the formula [Days Behind]@row * 257
Thank you in advance!
Answers
-
=IF([Days Behind]@row > 0, [Days Behind]@row * 257, 0)
Format the column as currency and there is no need to worry about dollar signs and decimals in the formula.
-
I would suggest a MIN function.
=MIN([Days Behind]@row, 0) * 257
-
Thanks Carson! That works!
The minimum function doesn't seem to return the correct result for some reason Paul.
Thanks for everyone's help!
-
Sorry about that. I was going too fast. It should be a MAX function. Time for another cup of coffee.
=MAX([Days Behind]@row, 0) * 257
-
I love this approach... making a note of it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!