Need Help
I will try and set this up so maybe someone can tell me what I am doing wrong:
Basically, I am getting a result and determining if it needs to be broken
out further nad trying to the answers input somewhere else to see if the
number of digits matches up.
So I get the result 6...then in one box I have 6 and in other I have 6...if
I get the result 3/12....then in one box I have 3 and in the other I have 12.
This number represents the number of digits required so if it does not match
6, 6, 3, or 12..then the input is incorrect. Right now, I am using an If
statement where if the length of whatever is in a cell matches 6,6,3, or 12
then put OK otherwise ERROR. Now, I can get it to work for the 6,6 but not
the 3 or 12 which are tied into a complicated process before hand. When I
check the length of character in the 3 or 12 boxes it shows me 2. Why is
that? Shouldn't that be 1? Any help would be greatly appreciated.
|