Start at the top
=if(a110,"c",if(a11,"b","a"))
or use a lookup table. Look in the help index for VLOOKUP
--
Don Guillett
SalesAid Software

"Tufail" wrote in message
...
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