if condition doubt
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
"deen" wrote:
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
|