Excel IF for multiple conditions question - IF(B2=C2,"Match","No Match"),IF(C2="-","None")

[McNeil87]

Hello,

I am looking to add a third condition to the following:

Part 1 of Formula.

• IF(B2=C2,"Match","No Match").

Part 2 of formula

• IF(C2="-","None")

How do i combine both of these formula together so that it either returns "Match", "No Match", or "None?" Note, None should only return was C2="-".

• Goal: IF(B2=C2,"Match","No Match"),IF(C2="-","None") -- this is not correct, how should i incorporate together correctly?

Is this an IF(OR) condition?

 

[Sufiyan97]

Hello,

I am looking to add a third condition to the following:

Part 1 of Formula.

• IF(B2=C2,"Match","No Match").

Part 2 of formula

• IF(C2="-","None")

How do i combine both of these formula together so that it either returns "Match", "No Match", or "None?" Note, None should only return was C2="-".

• Goal: IF(B2=C2,"Match","No Match"),IF(C2="-","None") -- this is not correct, how should i incorporate together correctly?

Is this an IF(OR) condition?

Try

=IF(C2="-","None",IF(B2=C2,"Match","No Match"))

 

[McNeil87]

Try

=IF(C2="-","None",IF(B2=C2,"Match","No Match"))

That worked -- thank you. Gosh, i had it backwards. Thank you!!!

 

[Sufiyan97]

That worked -- thank you. Gosh, i had it backwards. Thank you!!!

You're welcome & thanks for follow up!