Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
if function
dear
if i type 511 in cell A1 then in cell B1 there will be anil,if i type 512 in cell A1 then in cell B1 there will be sunil. if i type 513 in cell A1 then in cell B1 there will be amit. if i type 514 in cell A1 then in cell B1 there will be ritesh. is there any formula for this. pls help |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
if function
"hitesh" wrote:
if i type 511 in cell A1 then in cell B1 there will be anil,if i type 512 in cell A1 then in cell B1 there will be sunil. if i type 513 in cell A1 then in cell B1 there will be amit. if i type 514 in cell A1 then in cell B1 there will be ritesh. is there any formula for this. There are many ways to do this, depending on how robust you want to be about error conditions, i.e. when A1 is none of those values. Ignoring error conditions, you could write simply: =choose(A1-510,"anil","sunil","amit","ritesh") A little more bullet-proof: =if(and(511<=A1,A1<=514),choose(A1-510,"anil","sunil","amit","ritesh"),"") If you might have more than 29 names (the limit for CHOOSE), you might want to set up a table in a range and use VLOOKUP. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
if function
Enter in B1
=LOOKUP(A1,{511,512,513,514},{"anil","sunil","amit ","ritesh"}) Gord Dibben MS Excel MVP On Tue, 21 Apr 2009 23:54:01 -0700, hitesh wrote: dear if i type 511 in cell A1 then in cell B1 there will be anil,if i type 512 in cell A1 then in cell B1 there will be sunil. if i type 513 in cell A1 then in cell B1 there will be amit. if i type 514 in cell A1 then in cell B1 there will be ritesh. is there any formula for this. pls help |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
if function
"JoeU2004" wrote: "hitesh" wrote: if i type 511 in cell A1 then in cell B1 there will be anil,if i type 512 in cell A1 then in cell B1 there will be sunil. if i type 513 in cell A1 then in cell B1 there will be amit. if i type 514 in cell A1 then in cell B1 there will be ritesh. is there any formula for this. There are many ways to do this, depending on how robust you want to be about error conditions, i.e. when A1 is none of those values. Ignoring error conditions, you could write simply: =choose(A1-510,"anil","sunil","amit","ritesh") A little more bullet-proof: =if(and(511<=A1,A1<=514),choose(A1-510,"anil","sunil","amit","ritesh"),"") If you might have more than 29 names (the limit for CHOOSE), you might want to set up a table in a range and use VLOOKUP. thanks a lot. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
if function
"Gord Dibben" wrote: Enter in B1 =LOOKUP(A1,{511,512,513,514},{"anil","sunil","amit ","ritesh"}) Gord Dibben MS Excel MVP On Tue, 21 Apr 2009 23:54:01 -0700, hitesh wrote: dear if i type 511 in cell A1 then in cell B1 there will be anil,if i type 512 in cell A1 then in cell B1 there will be sunil. if i type 513 in cell A1 then in cell B1 there will be amit. if i type 514 in cell A1 then in cell B1 there will be ritesh. is there any formula for this. pls help thanks a lot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |