many ifs

[mfd2112]

I need a formula placed in cell M3 that will show as a letter “a” if cell C3 has the initials STA or CTA, and M3 would show as “c” if C3 has the initials GIL or STD, or show as “d” if C3 is DBL. If C3 is blank, M3 is also.
Any help is appreciated.
Dale

 

[jeffreybrown]

Hi Dale,

How about...

=IF(C3="","",IF(OR(C3={"STA","CTA"}),"a",IF(OR(C3={"GIL","STD"}),"c",IF(C3="DBL","d"))))

or you could even use a lookup table...

=IF(C3="","",VLOOKUP(C3,LkupTbl,2,0))

 

[Shweta]

Hi mfd2112,

Try this in M3:

=IF(OR(LEFT(C3,3)="sta",LEFT(C3,3)="cta"),"A",IF(OR(LEFT(C3,3)="gil",LEFT(C3,3)="std"),"C",IF(LEFT(C3,3)="dbl","D",IF(C3="",""))))

Hope this will help you.....

Shweta

 

[mfd2112]

Thanks you two, that was fast! <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I like them all and mostly <o></o>
<o></o>
=IF(C3="","",IF(OR(C3={"STA","CTA"}),"a",IF(OR(C3={"GIL","STD"}),"c",IF(C3="DBL","d"))))<o></o>
<o></o>
<o></o>from Jeffery, thanks again.<o></o>