if condition doubt

[deen]

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

 

[Mike H]

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,C19,2,FALSE)

In this case I put the table in C1 to D9

Mike

 

[Spiky]

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

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