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?