Hi all

I am a new user of Excel, i'm looking for a bit of help with the following.

I am using Excels RAND formula to mimic a die roll for a game i play, however associated with each die roll number i would like a message to be displayed giving instructions to the player, for example

=RANDBETWEEN(1,10)

IF(1) message A
IF(2) message B
.
.
.IF(10) message J



I am ok generating the Random number, but how do i associate a message to each value and display the message instead of the value?

Any help appreciated, like i said i am new to Excel so may need to walk me through it.

Thanks for any replies

regards

slipper