HELP! - IF Statement Issues

So, I know that this has got to be boneheaded simple, but I cannot get it.

I have a field in a cell that a user will enter a number into. I need to use some code in another field that will tell me what that number means to my org.

If the number is between 1-50, then "String 1"
If the number is between 51-999, then "String 2"
If the number is between 1000-10,000, then "String 3"
If the number is over 10,000, then "String 4"

I need some code that will examine the number and give me the proper string. I have beat my head against the wall trying to craft an IF statement that would do this, but it surpasses me.

Any help is greatly appreciated!

Hi MGeorges..

Try this formula....

I tried it with your example and it seems to work.

=IF(AND(A1>=1,A1<=50),"string 1",IF(AND(A1>=51,A1<=999),"string2",IF(AND(A1>=1000,A1<=10000),"string3","string4")))

Kelli

Hi Kelli:

Thanks much for your help here! I will try it!