if condition doubt

  • Thread starter Thread starter deen
  • Start date Start date
D

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
 
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,

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
Click to expand...

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