If formula

[Guest]

hello,
plz someone help mine, i am using following formula but there is some error,
what i want just if value less than 0 then A, if less than 10 but more than 1
then B, so on few.

=IF(A1<0,"A",)&IF(A1>1,"B",)&IF(A1>10,"C",""))

now what i have problam A & B are coming out but C doesn't comeout alone.

Thanks

 

[RichardSchollar]

Perhaps:

=IF(A1<0,"A",IF(A1<1,"",IF(A1<10,"B","C")))

But note that you didn't specify what to do given A1 being between 0
and 1 (so I have assumed "")

Hope this helps!

Richard

 

[Guest]

very sorry i couldn't give you enough information, anyway thank you very much
for soonest reply, have a very happy new year.(in advance)

 

[John Bundy]

This works, you need the and to say it is greater than 1 but less than 10
=IF(A1<0,"A",IF(AND(A1>1,A1<10),"B",IF(A1>10,"C","")))
also you need to add a few = where you need them, for example if A1=10 then
the answer is ""

 

[Don Guillett]

Start at the top
=if(a1>10,"c",if(a1>1,"b","a"))
or use a lookup table. Look in the help index for VLOOKUP