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