text IF
 

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?

text IF
 

One way:

=IF(D19="sch","liz",IF(D19="TCh","lex",IF(D19="POS ","mav","other")))

However, you're limited to 7 levels of nesting pre-XL07.

You may do better with a lookup. For instance:

J K
1 sch liz
2 TCh lex
3 POS mav

Then use the formula

=VLOOKUP(D19,J:K,2,FALSE)

or, if it's possible that D19 has a value not in the table:

=IF(ISNA(VLOOKUP(D19,J:K,2,FALSE)),"other",VLOOKUP (D19,J:K,2,FALSE)




In article ,
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?

text IF
 

Thanks for your reply. My formula looks like the first one, as i only have
five, 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


"JE McGimpsey" wrote:

One way:

=IF(D19="sch","liz",IF(D19="TCh","lex",IF(D19="POS ","mav","other")))

However, you're limited to 7 levels of nesting pre-XL07.

You may do better with a lookup. For instance:

J K
1 sch liz
2 TCh lex
3 POS mav

Then use the formula

=VLOOKUP(D19,J:K,2,FALSE)

or, if it's possible that D19 has a value not in the table:

=IF(ISNA(VLOOKUP(D19,J:K,2,FALSE)),"other",VLOOKUP (D19,J:K,2,FALSE)




In article ,
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?

text IF
 

Check your other thread.

Be18 wrote:

Thanks for your reply. My formula looks like the first one, as i only have
five, 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

"JE McGimpsey" wrote:

One way:

=IF(D19="sch","liz",IF(D19="TCh","lex",IF(D19="POS ","mav","other")))

However, you're limited to 7 levels of nesting pre-XL07.

You may do better with a lookup. For instance:

J K
1 sch liz
2 TCh lex
3 POS mav

Then use the formula

=VLOOKUP(D19,J:K,2,FALSE)

or, if it's possible that D19 has a value not in the table:

=IF(ISNA(VLOOKUP(D19,J:K,2,FALSE)),"other",VLOOKUP (D19,J:K,2,FALSE)




In article ,
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