LinkBack URL
About LinkBacks
If I enter a 7 digit number in to A1 I want '1' to be diplayed in B1, if a 5 digit number is entered in A1 I want '2' to be displayed in B1. Any other amount of numbers or text are to display 'UNKNOWN'.
Please help.
Display 'UNKNOWN' in a cell if the criteria doesn't match
If I enter a 7 digit number in to A1 I want '1' to be diplayed in B1, if a 5 digit number is entered in A1 I want '2' to be displayed in B1. Any other amount of numbers or text are to display 'UNKNOWN'.
Please help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks