IF function with triple condition & range

[AdamS92]

Greetings,

im trying to achieve a single function where the following happens:

=IF(M3<30, "30 Days or less",""
=IF(M3>=31<=60, "30 to 60 days"
=IF(M3>=61<=90, "60 to 90 days"

So essentially, I'm looking at a bunch of resources where i want to see when their contract is due and separate it into 3 categories: 30 Days or less, 30 to 60 days and 60 to 90 days.
Number of Contracted days left is in column M

I understand how to develop something similar using =IF(and( as long as the values I'm comparing are static and not like in this case a range of "in between" also.

Thank you & any help or advice is much appreciated.
A

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(M3<=30, "30 Days or less",IF(M3<=60, "30 to 60 days",IF(M3<=90, "60 to 90 days","")))

 

[Legacy 143009]

How about like this:

=LOOKUP(M3,{0,31,61,91},{"30 days or less","30 to 60 days","60 to 90 days","above 90 days"})

 

[AdamS92]

Hi & welcome to MrExcel.
How about

=IF(M3<=30, "30 Days or less",IF(M3<=60, "30 to 60 days",IF(M3<=90, "60 to 90 days","")))

How about like this:

=LOOKUP(M3,{0,31,61,91},{"30 days or less","30 to 60 days","60 to 90 days","above 90 days"})

Thank you both, this was extremely fast. I really appreciate your help.

Both solutions do the job perfectly.

Have a Great Day.
A

 

[Legacy 143009]

Happy to help! Thanks for the feedback

 

[Fluff]

Glad we could help & thanks for the feedback.