View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Skip
 
Posts: n/a
Default Need to have cell C8 contain contents of Cell G(formula)

Need to have cell C8 contain contents of cell
G(=ROUND(RAND()*(10-1)+1,0))
Or something simular.

Cell G(1:10) contain strings that I am trying to randomize just one of the
10 into cell C8.

I am trying to say " =G(ROUND(RAND()*(10-1)+1,0)) " but this does not work.

Can you help??