Perhaps an easier way is to use randbetween within say, a vlookup with a
"standalone" table array, something like:

In any cell, say B2:
=VLOOKUP(randbetween(0,3),{0,"spades";1,"clubs";2, "diamonds";3,"hearts"},2,0
)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dogdoc1142" wrote in message
...
I am trying to use the rand function to generate an interger between 0-3.
Depending on the result, I'm attempting to assign a text value i.e. if
rand()*3=1,"spades","clubs". The process will work only once. When I use
F9
to generate a new random number, the text value remains the same
regardless
of the new result for rand()*3. How do I get Excel to generate a new text
value, based on the new random number?