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

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

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)

"RichardSchollar" wrote:

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

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

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

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

"RichardSchollar" wrote:

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

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