Text in a IF formula

[Guest]

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?

 

[Guest]

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

 

[Alan]

=IF(D19="sch","liz",IF(D19="Tchi","lex",IF(D19="POS","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.

 

[Guest]

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

 

[Alan]

It sounds like the cell is formatted as text, select it and click in the
formula bar and hit F2,
Regards,
Alan.

 

[Dave Peterson]

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.

 

[Don Guillett]

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.