How To Write This =IF Formula

[ssjagger]

In cell A1 I would insert value from 0 to 999

What I'm trying to do is

If the value of A1 is equal or greater than 0, but equal or less than 333, the answer would be 1
If the value of A1 is equal or greater than 334, but equal or less than 666, the answer would be 2
If the value of A1 is equal or greater than 667, but equal or less than 999, the answer would be 3

Here is how I'ver tried to write it, but no matter what value I put if A1, I keep getting an anwer of 1?

=IF(A1<=0>=333,1,IF(A1<=334>=666,2,IF(A1<=667>=999,3)))

Thanks is advance for your help.

[Jonmo1]

Try a lookup

=LOOKUP(A1,{0,334,667,1000},{1,2,3,""})

You didn't specify what should happen if the value is 1000+ or Below Zero.
So I've assumed the value won't be below 0, and that you want a blank if it's 1000+

If the value IS below 0 or if it's text, then it will return #N/A

[Debraj Roy]

try This..

Please Login or Register  to view this content.

Ottawa... I hope.. no need to swap ";" and "," but if doesn't work.. then swap as suggested..

[Fotis1991]

One way is this.

=IF(AND(A1>0,A1<=333),1,IF(AND(A1>=334,A1<=666),2,IF(AND(A1>=667,A1<=999),3,"")))

[ssjagger]

Excellent! Thanks for your help all.

[Jonmo1]

You're welcome.

[Fotis1991]

........................