I did the parenthisis and tried several combinations - the darn thing will
not work.

Any thoughts on my formula and thanks for your formula but I would like to
solve my issue

"Todd F." wrote:

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