change last digit in cell if it is a zero

[Gastank]

Hi,

looking for help please,

In Excel 2010 I am generating a random 5 digit number in cell A1 and I am using the last digit to select the corresponding letter from a word in another cell.

e.g. A1 = 45678 - last digit = 8 corresponding letter from the word "Subscribed" = b

however if A1 = 45670 - last digit = 0 then I receive an error message in my letter selection cell.
Is there a way to automatically change last digit in Cell A1 if it is a zero to any number between 1 and 9.

thanks in advance for any help.

 

[Snakehips]

Hi,

In Excel 2010 I am generating a random 5 digit number in cell A1 and I am using the last digit to select the corresponding letter from a word in another cell.

e.g. A1 = 45678 - last digit = 8 corresponding letter from the word "Subscribed" = b

however if A1 = 45670 - last digit = 0 then I receive an error message in my letter selection cell.
Is there a way to automatically change last digit in Cell A1 if it is a zero to any number between 1 and 9.

Another thought.
How typical is 'Subscribed' as the word you are selecting from?
As it has 10 letters can you accept any trailing digit 0 - 9 on your random number and use something like below for the selection?

=MID("Subscribed",RIGHT(A1,1)+1,1)