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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives