Hi All
I'm testing a spreadsheet I've been working on (with some much appreciated forum help). Where the data in a cell should be in the format BD1, BD2 etc up to BD10 - when error values are entered, the formula is reading the number value ** any 'letter number' combination whereas if two letters or two numbers are entered it throws up a #VALUE!.
you cant have right() as a length 0f 0
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
In J you have
=VALUE(RIGHT(I10,LEN(I10)-2))
and where you have #Value is where the data in I10 is only 2 characters
so that returns a blank which you are then using value on
so all 2 characters in I will give value
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you for your replies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks