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.
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.