Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"Dogdoc1142" wrote:
I am trying to use the rand function to generate an interger between 0-3. =int(4*rand()) Depending on the result, I'm attempting to assign a text value i.e. if rand()*3=1,"spades","clubs". =index({"hearts","spades","diamonds","clubs"},1+in t(4*rand())) Note: You do not really need int(...) in this context. 1+4*rand() will suffice. |