How to check if the column contains values that are not numbers but also exclude blanks?-CodePudding

Title is pretty much the question, but I'm trying to check if there's an efficient way to check if two columns (not infinite) contain values that are not numbers.

I've tried to use something like

=ARRAYFORMULA(IF(ISNUMBER(A2:A), IF(ISNUMBER(B2:B), "", "errB"), "errA"))

but the problem with this is that it also counts blanks and I feel like expanding the formula by using <> to exclude blanks is inefficient.

any tips and guidance are appreciated!

CodePudding user response：

I understand that you want a formula to check if two cells from different columns are numbers or not. I will assume that you want a TRUE result if both cells are numbers, and FALSE otherwise. This is the formula that fits those requirements:

=AND((IF(ISNUMBER(A2:A), "TRUE", "FALSE"))="TRUE",(IF(ISNUMBER(B2:B), "TRUE", "FALSE"))="TRUE")

I have used the same IF(ISNUMBER()) structure as your example. I only added the

CodePudding user response：

Here is a simple solution:

=COUNTIF(A:B,"><")

Norwegian Sheets - so change ";" with ","