IF Function With Multiple Values

Options
dpatel
dpatel
edited 12/09/19 in Smartsheet Basics

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

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    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)