=If(A1:D1="Pass","Y","N")

[Gaurav]

How do I say this?

to explain it better, I want to use more than 2 arguments in the EXACT
function. If all are same then Y if even one of them is different then N.

Any help is appreciated.

Regards

 

[Pete_UK]

Try it this way:

=IF(COUNTIF(A11,"Pass")=4,"Y","N")

Checks to see if all the cells in A11 are set to "Pass", if so
returns "Y".

Hope this helps.

Pete

 

[Lars-Åke Aspelin]

How do I say this?

to explain it better, I want to use more than 2 arguments in the EXACT
function. If all are same then Y if even one of them is different then N.

Any help is appreciated.

Regards

Try this formula
It is an array formula that has to be confirmed by CTRL+SHIFT+ENTER
rather than just ENTER

=IF(AND(A11="Pass"),"Yes","No")

Hope this helps / Lars-Åke

 

[Teethless mama]

None array enter

=IF(AND(INDEX(A11="Pass",)),"y","n")