IF Function With Multiple Values

dpatel

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. 

Mike Wilday

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)