SOLVED

New Contributor

# IFS function

'In excel I'm trying to use the IFS function to say the following: if A1 is between 0-150, then return a value of "1." If A1 is between 151-300, then return a value of "2."  If A1 is between 301-450, then return a value of "3."

3 Replies

# Re: IFS function

Or is there a better function to use than IFS?
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: IFS function

``=IF(AND(A1>=0,A1<=150),1,IF(AND(A1>=151,A1<=300),2,IF(AND(A1>=301,A1<=450),3)))``

An alternative is a nested IF formula. The syntax of IFS is a bit easier however.

# Re: IFS function

Great, thank you so much! It's just always hard figuring out where the AND and the parenthesis go...