Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if condition doubt
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if condition doubt
On May 2, 6:03 am, 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 You can only nest 7 IFs, I think. You have 9 listed there. Definitely try a VLOOKUP instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Doubt | Excel Discussion (Misc queries) | |||
Macro doubt | Excel Discussion (Misc queries) | |||
I have a doubt! | Excel Discussion (Misc queries) | |||
Vlookup doubt.. | Excel Discussion (Misc queries) | |||
some doubt | Excel Worksheet Functions |