Error Check Formula

[jimmyaja123]

I have created an error check formula based on character length limit in another cell 'E2, G2' etc, image example provided

=+IF(OR(LEN($E20)=$E$2,"OK",LEN($G20)=$G$2,"OK",LEN($N20)<=$N$2,"OK",LEN($I20)<=$I$2,"OK",LEN($L20)<=$L$2,"OK",LEN($P20)<=$P$2,"OK",LEN($R20)<=$R$2,"OK"),"Error")

The problem i'm having is even if the character limit is not passed, the final result always says 'Error'? Is there something i've written incorrectly in the formula?

 

[etaf]

not sure your OR() is correct

=+IF(OR(LEN($E20)=$E$2,"OK",LEN($G20)=$G$2,"OK",LEN($N20)<=$N$2,"OK",LEN($I20)<=$I$2,"OK",LEN($L20)<=$L$2,"OK",LEN($P20)<=$P$2,"OK",LEN($R20)<=$R$2,"OK"),"Error")

OR(LEN($E20)=$E$2,"OK",LEN($G20)=$G$2,"OK",LEN($N20)<=$N$2,"OK",LEN($I20)<=$I$2,"OK",LEN($L20)<=$L$2,"OK",LEN($P20)<=$P$2,"OK",LEN($R20)<=$R$2,"OK")

should it be
OR(LEN($E20)=$E$2,LEN($G20)=$G$2,LEN($N20)<=$N$2,LEN($I20)<=$I$2,LEN($L20)<=$L$2,LEN($P20)<=$P$2,LEN($R20)<=$R$2)

AND then
IF ( OR(LEN($E20)=$E$2,LEN($G20)=$G$2,LEN($N20)<=$N$2,LEN($I20)<=$I$2,LEN($L20)<=$L$2,LEN($P20)<=$P$2,LEN($R20)<=$R$2) , "OK", "ERROR")

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

You have not explained exactly what you want the formula to do, but my guess is this.

=IF(OR(LEN($E20)=$E$2,LEN($G20)=$G$2,LEN($N20)<=$N$2,,LEN($I20)<=$I$2,LEN($L20)<=$L$2,LEN($P20)<=$P$2,LEN($R20)<=$R$2,),"OK","Error")