Mar 19 2023 11:40 AM
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!
Mar 19 2023 12:10 PM
Please provide more detailed and specific information.
Mar 19 2023 04:49 PM
Mar 20 2023 03:58 AM
If you would like help with this, please explain in detail what you want.
Mar 20 2023 06:04 AM
You can use the COUNTIFS function to count cells across multiple ranges based on one or several conditions.
The function is available in Excel 365, 2021, 2019, 2016, 2013, Excel 2010, and Excel 2007.
Here’s an example of how to use COUNTIFS with multiple criteria in the same column in Excel:
=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.