IF then help or suggestions

[stefan123]

I have a 2 columns:


A B
NMC Yes
NMC NO
NMC
NMC YES
NMC YES

I want to insert in column C if the criteria are (NMC and Yes) or (NMC and Blank), then it can be recoded into NMCI. I have tried if then statements but none of them have worked. Help or suggestions on this data transformation?

 

[Somendra Misra]

Hi Stephen123,

Welcome to Chandoo.org forum.

Can you tell what your output data would look like?

Regards,

 

[stefan123]

A B C
NMC Yes NMCI
NMC NO
NMC NMCI
NMC YES NMCI
NMC YES NMCI

 

[Somendra Misra]

@stefan123

Suppose your values in A1:A5 = NMC and B1:B5 Yes, No, or a blank. Try below formula in C1 and copy down.

=IF(OR(AND(A1="NMC",B1="Yes"),AND(A1="NMC",B1="")),"NMCI","")

Regards,