| 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 |
| 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 | |||
Threaded Mode
