Hello all,
Hope you can help me what am I doing wrong with this formula,
What I need in the formula is to count the number of characters in a cell and to return a message ("Review" or "OK") depending on the condition given.
For example, if the cell A2 is specified as "hourly", then I need that the value in B2 is no longer than 9 characters and if so, C3 cell display "Review" or if B2 is shorter that 9 characters display "OK"
This is the formula I'm using:
=IF(A2="Hourly",IF(LEN(B2)>9,"Review",IF(LEN(B2)>6,"Review","OK")))
It works when the cell A2 is specified as hourly, however, if A2 have any other value it displays a FALSE error, and what I need is that if A2 is not specified as hourly validate that B2 cell is not longer to 6 characters, and display "OK" or "Review" depending on the compliance of the condition
Hope I made myslef clear,
Thanks for your help
Bookmarks