Need to have cell C8 contain contents of Cell G(formula)

[Skip]

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??

[Dave Peterson]

=indirect("G"&round(rand()*(10-1)+1,0))
or
=index(g1:g10,rand()*(10-1)+1)



Skip wrote:
>
> 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??

--

Dave Peterson