If statement issue

[punter]

Hi,

I'm having a problem with an IF statement. I'm trying various things but I can't get it to work the way I want. The statement is below:

=IF(M2="DC9011","DC",IF(M2="DC9021","DC","DSD"))

What this is doing is returning DC if either DC9011 or DC9021. If M2 is not DC9011 or DC9021 then it is returning DSD. It works fine for what it is doing now but I would like to add something else to to it. I'm not always sure that there will be data in cell M2 and right now the formula is returning DSD if M2 is blank.

What I would like it do it leave the cell blank if M2 is blank. I'm trying various IF, AND, and Or statements with <>"" but I can't get it to work.

Any thoughts are more than welcome.

Thanks

Eddie.

[VBA Noob]

Hi,

Try

=IF(M2="","",IF(OR(M2="DC9011",M2="DC9021"),"DC","DSD"))

VBA Noob

[punter]

That worked awesome. Thanks

Eddie.

[VBA Noob]

Glad it worked for you


VBA Noob