Try it this way:

=IF(COUNTIF(A1:D1,"Pass")=4,"Y","N")

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

Hope this helps.

Pete

On Jul 22, 2:26*pm, "Gaurav"
wrote:
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