nested if then statements - can you help?

[BigEz]

Looking for help with a statement that does something like this:

If cell A1 is equal to or greater than 1 but less than 2, then return the words "not bad." If cell A1 is equal to or greater than 2 but less than 3, then return the words "pretty good." If cell A1 is equal to or greater than 3 but less than 4, then return the words "very good." If cell A1 is equal to or greater than 4 but less than 5, then return the words "very good." If cell A1 is equal to or greater than 5 "fantastic!"

What might it look like? I've been chasing my tail! Thanks!

BigEz

[ConneXionLost]

How about:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Cheers,

[Fotis1991]

Hi BigEz

Pls try this:

Please Login or Register  to view this content.

Hope to helps you.

[limxrich]

=IF(AND(A1>=1,A1<2),"not bad",IF(AND(A1>=2,A1<3),"pretty good",IF(AND(A1>=3,A1<4),"Very Good",IF(AND(A1>=4,A1<5),"Impressive",IF(A1>=5,"FANTASTIC")))))

**changed 4-5 to impressive instead of repeating "very good"