Hi,Am Sat, 3 May 2014 21:21:50 +0100 schrieb slipper:

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

your RAND formula in A1. Then:

=CHOOSE(A1,"MessageA","MessageB","MessageC","Messa geD","MessageE",.........)

Or you write the numbers from 1 to 10 e.g. in L1:L10 and in M1:M10 the
depending messages. Then you can try it with:

=VLOOKUP(A1,$L$1:$M$10,2,0)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional