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