jimmyaja123
New Member
- Joined
- Jan 6, 2021
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
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?
=+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?