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.