Help! IFS Formula with a ranged criteria?

Hi,
I'm having some trouble with the IFS formula. I have tried both IFS and IF, without any success.

Basically, I'm pulling data with a random range of 1-100.


If the data is less than (or equal to) "49", then I need to return the value "Too short!"

If the data is equal to the range of "50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60", then I need to return the value "Perfect!"

If the data is greater than (or equal to) "61", then I need to return the value "Too long!"



I have managed to get the less than and greater than to work, and independently I have managed to get the equal to a range to work, BUT I can't seem to get these to work together. I need this function in one cell, and it's giving me a bit of a headache.
Can someone give me a hand here?

Post the formula(s)

DH welcome to the forum.

With data 1-100 in column A try this formula in B1 and fill down.

Formula:

Please Login or Register  to view this content.

If it has to be the IFS function I don't have Excel 2016, but from reading the documentation I believe this would work.

Formula:

Please Login or Register  to view this content.

DestynnieHall welcome to the forum

(Windows 10 is your operating system, not your MS office version please update with your Office version - 2016, 365, Mac etc)

I have 2016 desktop and IFS() (along with a few other new functions are not included (for FT)

Based on your example...
=if(A1<=49,"too short",if(A1>=61,"too long","perfect"))

If the data is less than (or equal to) "49", then I need to return the value "Too short!"
If the data is equal to the range of "50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60", then I need to return the value "Perfect!"
If the data is greater than (or equal to) "61", then I need to return the value "Too long!"

Originally Posted by FDibbins

I have 2016 desktop and IFS() (along with a few other new functions are not included (for FT)

Thanks Ford for filling me in. Didn't know about that one. Online docs I have been using are kind of 'sketchy'.