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


Tufail wrote:
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(A11,"B",)&IF(A110,"C",""))

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

Thanks