If formula for values between

[slinky192001]

Hello,

In column A i have a list of random numbers which can range between 0 and 700. I want to create and IF statement that will look at column A and say:

If A is less than 5 the "0 - 5 Days", IF A is between 5 and 30 then "5 - 30 Days", IF A is between 31 and 90 then "31 - 90 Days" and so on

I cannot figure out how to show between?

Any help would be greatly appreciated.

Thanks
C

 

[VoG]

Try

=LOOKUP(A1,{0,5,31,91},{"0-5D","5-30D","31-90D",">90D"})

 

[StuLux]

You need to do an AND statement as well as the IF i.e.

=IF(A<5,"0-5 days",IF(AND(A>=5,A<=30),"5-30 days" etc. etc.

However there are more elegant solution to this and you would be better to build a table to look up the necessary values if you have more than a few IF's

or......... use the more elegant solution supplied by VOG!