Simple indicator

[Kybynn]

I would like to create an indicator.

This indicator should display "OK" when two columns both either display a bunch of letters in the same row or both of the columns display a value of 0.

The indicator should display "ERROR" if the left column displays a 0 and the right column displays a bunch of letters.

I have been trying:

=IF(AND(B3:B17=0,C3:C17<>0),"ERROR","OK")

But that does not work.

The following example might help:

Simple example.xlsx

Thanks already!!!

[benishiryo]

hi Kybynn, try this:
=IF(OR(AND(ISTEXT(B3),ISTEXT(C3)),AND(B3=0,C3=0)),"OK","ERROR")

[vlady]

or like this ???
don't know if this is applicable also.

=IF(COUNT(G3:G17)<>COUNT(H3:H17),"Error","OK") - counts 0
or
=IF(SUMPRODUCT((G3:G17<>H3:H17)+0)>0,"Errors","Ok") - check every row if same

[Kybynn]

Thanks a lot! In the end, I used =IF(COUNT(G3:G17)<>COUNT(H3:H17),"Error","OK").

Stars for everyone!!!

Cheers!

[vlady]

Your Welcome from both of us. don't forget to mark this thread as "solved" thanks.

[Kybynn]

Thanks for the reminder. I find it just amazing, that someone as young as you is capable using a computer and be so good at Excel!

Very nice!

[benishiryo]

realised i got your question wrongly. =x
thanks for the rating anyway!