SUMPRODUCT or IF(AND ?

[tarynmahon]

I need a formula that says;

If A does not equal B, and A does not equal C return the result in D


whats the best way of doing this please?

 

[mgesh2002]

tarynmahon,


May be this formula works for you


=IF(OR(J26=J27, J26=J28), "Matching", "Not Matching")

Returns Matching if any argument is TRUE; returns Not Matching if all arguments are FALSE