=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?