RAND Breakdown

The answer to this is probably simple and I'm just missing it.

I want to generate a random number using RANDBETWEEN(). Then I want to break it into 3 parts and asign a text code to each part. It seems that using the IF function (such as -IF(A1=1,"Th","") for example) does not work on the cell with the parsed number.

I guess the best way to understand is to look at the attached worksheet.

(PLEASE- NO MACROS. My workplace does not allow them)

RAND Breakdown.xlsx

It would be easiest to use a look-up table to translate the values to letters.

Your IF statment isn't working because when you split the random number, using a string function (LEFT, MID, RIGHT) the portion you return is a string, so while IF(A1=1 won't work IF(A1="1" should

BINGO! I knew it had to be something simple that I was missing! Thanks Andrew-R !!