Excel evaluates RAND() only once.

Yeah, that's why I prefaced with:

Here's a long shot

This is pretty slick:

=SUBSTITUTE(REPT("+RAND()",23),"+","=",1)
Press [F9] then press [Enter].

I briefly thought about something along those lines but didn't actually try
it.


--
Biff
Microsoft Excel MVP


"Harlan Grove" wrote in message
...
"T. Valko" wrote...
Here's a long shot:
...
=SUM(RAND()*(ROW(INDIRECT("1:23"))/100))
...

Doesn't work. Excel evaluates RAND() only once.