The ExcelHelpDesk Support team received the following request for help
Problem – checking for specific cell values
Please help me with a formula
I want to say that if columns B to BX = A or N/A then True, otherwise False.
I just can’t seem to find the right formuala!!!
Debbie…
Here is a sample of the file sent through that shows what was needed
Solution – Create a formula to set the Value
The formula needed to calculate the number of non-empty cells for each row and then compare that to the number of cells that had “A” or “N/A” included. If that number differed then the result needed to be FALSE, if it matched then the result was TRUE.
The formula needed was
=IF(COUNTA(B2:AX2)=(COUNTIF(B2:AX2,"A")+COUNTIF(B2:AX2,"N/A")),TRUE,FALSE)
If you have a question on this post for the Excel Help Desk team or have something you would like to share on this topic then please leave a comment