IF AND Formula with multiple conditions

[thomassharp]

Hi,I am trying to use IF formula to show whether a row of cells matches:

[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Dog[/TD]
[TD="width: 64"]Dog[/TD]
[TD="width: 64"]Dog[/TD]
[TD="width: 64"]Fish[/TD]
[TD="width: 64"]Near Match[/TD]
[/TR]
[TR]
[TD]Dog[/TD]
[TD]Dog[/TD]
[TD]Fish[/TD]
[TD]Fish[/TD]
[TD]Partial Match[/TD]
[/TR]
[TR]
[TD]Cat[/TD]
[TD]Pig[/TD]
[TD]Fish[/TD]
[TD]Dog[/TD]
[TD]No Match[/TD]
[/TR]
[TR]
[TD]Pig[/TD]
[TD]Pig[/TD]
[TD]Pig[/TD]
[TD]Pig[/TD]
[TD]Full Match[/TD]
[/TR]
</tbody>[/TABLE]

I have tried =IF(A2=B2,"Partial Match","No Match")IF(AND(A2=B2,A2=C2),"Near Match","No Match"))
But obviously this doesn't work.

Very interested in the logic of the syntax needed here...

Thanks!

 

[ayushthakur]

=IF(A1=B1,IF(B1=C1,IF(C1=D1,"Full Match","Near Match"),"Partial Match"),"No Match")

This also works fine

 

[thomassharp]

=IF(A1=B1,IF(B1=C1,IF(C1=D1,"Full Match","Near Match"),"Partial Match"),"No Match")

This also works fine

Only if the values are in that order

 

[Ruddles]

Because the first formula generates a value from 0 to 6 (seven values) but the CHOOSE needs to start at 1. So I turn the range 0-6 to 1-7 by adding 1.

Did I explain that well?

Of course there are some values which aren't possible.

That solution - the first formula I posted - allows you to compare whether one line is more of a match than another line, if you need to do that.

R.