if condition doubt

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deen - 02 May 2008 12:03 GMT

Hi,

This condition is not working in excel, kindly guide me what is the
way to workin( there is any possible in macro)

=IF(and(B4="m"),1,IF(and(B4="e"),2,IF(and(B4="r"),3,IF(and(B4="c"),
4,IF(and(B4="h"),5,IF(and(B4="a"),6,IF(AND(B4="n"),7,IF(and(B4="t"),
8,if(and(b4="s"),9)))))))))

regards,

deen

Reply to this Message

Mike H - 02 May 2008 12:31 GMT

Hi,

I'm not entirely clear what you are trying to do but a table that seems to
describe it might look like this

m    1
e    2
r    3
c    4
h    5
a    6
n    7
t    8
s    9

If thats corect put that table in some place on your worksheet and try this
formula
=VLOOKUP(B4,C1:D9,2,FALSE)

In this case I put the table in C1 to D9

Mike

> Hi,
>
[quoted text clipped - 8 lines]
>
> deen

Reply to this Message

Spiky - 02 May 2008 18:14 GMT

> Hi,
>
[quoted text clipped - 8 lines]
>
> deen

You can only nest 7 IFs, I think. You have 9 listed there. Definitely
try a VLOOKUP instead.

Reply to this Message