A few too many brackets
=IF(I2<30, "<30", IF(AND(I2=30, I2<=60),"31-60",
IF(AND(I260,I2<=90),"61-90", IF(I2=91, " 91"))))
This will work

You can simplify.........no need for the AND functions

=IF(I2<30, "< 30", IF(I2<=60,"31-60", IF(I2<=90,"61-90", " 91")))

You may want to change the class "<30" to "<=30" if you have the next class
from 31 to 60.
And show the last as "90"

=IF(I2<=30, "<= 30", IF(I2<=60,"31-60", IF(I2<=90,"61-90", " 90")))


--
Greetings from New Zealand
Bill K

"Todd F." wrote in message
...
I searched & searched for an old post to cover this but nothing out there.

I have the following formula that is got an error in it:

=IF(I2<30, "< 30"), IF(AND(I2=30, I2<=60),"31-60"), IF(AND(I260,
I2<=90),"61-90"), IF(I2=91, " 91")

my goal is tot have the following for statements placed in a cell via this
calculation to cover 4 possible variables.

if number is then or equal to 30 then tag "<30"
if number is 31 or greater and 60 or less then tag "31-60"
if number is greater then 60 but less then or equal to 90 then tag "61-90"
if number is greater then or equal to 91 then tag "91+"

I use to do these all the time what is up with this formula:

Thanks Todd Frisch