IF Function With Multiple Values
I need help with an IF function with multiple values. If value x is 30 or less, I need it to return $250. Then, if that same value is 31 to 99, I need it to return $500. Lastly, if the value is over 100, I need it to return $1,000. I need one function to include all this. You can just refer to the value as x if any of you have a formula to work for this. If value x is between the numbers I listed above, I need it to return the dollar figures listed above.
Comments
-
Use the following formula but replace "Column Title" with your actual column tile and update the formula row (I used a sample of 24) with whatever row you are actually referencing.
=IF([COLUMN TITLE]24 <= 30, 250, IF([COLUMN TITLE]24, IF(AND([COLUMN TITLE]24 > 30, [COLUMN TITLE]24 <99), 500, IF([COLUMN TITLE]24 >100, 1000)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives