# Excel formula

Copper Contributor

# Excel formula

I need to create a formula with nesting, I believe, to address if one OR the other is true. I tried IF/OR function as well as IF/AND.  I keep getting error messages.  HELP!

4 Replies

# Re: Excel formula

Please provide more detailed and specific information.

# Re: Excel formula

Actually, I need to use COUNTIF x2 for the same range but different criteria. Only one of the criteria need met to render "Fail", "Pass"

# Re: Excel formula

If you would like help with this, please explain in detail what you want.

# Re: Excel formula

You can use the COUNTIFS function to count cells across multiple ranges based on one or several conditions.

=IF(COUNTIFS(A1:A10,"Fail",A1:A10,"Pass")>0,"Fail","Pass")

This formula will return “Fail” if either of the criteria is met, and “Pass” if neither of the criteria is met.

I hope this helps!

Otherwise, I recommend you, as Mr.Hans Vogelaar

has already informed you, provide more detailed and specific information.