#### Steve Swift

##### Board Regular

- Joined
- Jan 18, 2004

- Messages
- 187

Can someone help with this what I am sure is an easy problem?

I have cell A2 in which the user will type a number, as a result of the size of the number I need B2 to display a different number. I guess its an IF in B2 nested but can't figure it out. This is what I need

IF A2 is equal to or greater than zero and less than or equal to 999 "20"

IF A2 is equal to or greater than 1000 and less than or equal to 4999 "18"

IF A2 is equal to or greater than 5000 and less than or equal to 9999 "15"

IF A2 is equal to or greater than 10000 "12"

Hope that makes sense and that someone can help.

Thanks

Steve