| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text in a IF formula
I want to use text as a logical in an IF formula which I am sure you must be
ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in a IF formula
Text values need to be enclosed in doulbe quotes. So, your formula should
look something like: =IF(D19="sch","liz",IF(D19="tch","lex",IF(D19="pos ","mav",""))) HTH, Elkar "Be18" wrote: I want to use text as a logical in an IF formula which I am sure you must be ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in a IF formula
=IF(D19="sch","liz",IF(D19="Tchi","lex",IF(D19="PO S","mav","")))
These are called Nested IF's. You can only use a maximum of seven of them in one formula. You can use text in all formulas, just use the double quotes in front and behind the string, eg "Text" Regards, Alan. "Be18" wrote in message ... I want to use text as a logical in an IF formula which I am sure you must be ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in a IF formula
Thanks for your reply. My formula looks very much like that, however when i
click out of the box it doesn't calculate and i can still see the formula! Any extra help? Thank u very much "Elkar" wrote: Text values need to be enclosed in doulbe quotes. So, your formula should look something like: =IF(D19="sch","liz",IF(D19="tch","lex",IF(D19="pos ","mav",""))) HTH, Elkar "Be18" wrote: I want to use text as a logical in an IF formula which I am sure you must be ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in a IF formula
It sounds like the cell is formatted as text, select it and click in the
formula bar and hit F2, Regards, Alan. "Be18" wrote in message ... Thanks for your reply. My formula looks very much like that, however when i click out of the box it doesn't calculate and i can still see the formula! Any extra help? Thank u very much "Elkar" wrote: Text values need to be enclosed in doulbe quotes. So, your formula should look something like: =IF(D19="sch","liz",IF(D19="tch","lex",IF(D19="pos ","mav",""))) HTH, Elkar "Be18" wrote: I want to use text as a logical in an IF formula which I am sure you must be ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in a IF formula
I think Alan meant
change the format from Text to General select the cell format|cells|Number tab|General category then select the cell and hit F2, then enter. It's enough to force excel to notice that it's really a formula. Alan wrote: It sounds like the cell is formatted as text, select it and click in the formula bar and hit F2, Regards, Alan. "Be18" wrote in message ... Thanks for your reply. My formula looks very much like that, however when i click out of the box it doesn't calculate and i can still see the formula! Any extra help? Thank u very much "Elkar" wrote: Text values need to be enclosed in doulbe quotes. So, your formula should look something like: =IF(D19="sch","liz",IF(D19="tch","lex",IF(D19="pos ","mav",""))) HTH, Elkar "Be18" wrote: I want to use text as a logical in an IF formula which I am sure you must be ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text in a IF formula
Have a look in the help index for LOOKUP. And, Please quit posting the same
question all over the place. Not a good way to make friends. -- Don Guillett SalesAid Software "Be18" wrote in message ... I want to use text as a logical in an IF formula which I am sure you must be ablr to do but I can't seem to figure it out. For example if D19 is sch, i want E19 to = liz but if D19 is TCh i want E19 to = lex or if D19 is POS then E19 = mav etc. Please can someone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
| how to convert a formula into text in order to display the formula | Excel Discussion (Misc queries) | |||
| Copy formula so destination displays formula as text | Excel Discussion (Misc queries) | |||
| Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
| match cell text with text in formula | Excel Worksheet Functions | |||
Linear Mode
