using randombetween to arrive at dollars and cents

[Bob Arnett]

I'm trying to get a series of random monetary numbers that are between $0.01
and $99.99. Using "=randombetween(.01,99.99)" seems to only give the dollars
and makes no cents (pun intended).
The only way I've figured to do this is by using the formula
"=RANDBETWEEN(1,99)/100+RANDBETWEEN(1,99)".
Is there a more elegant way?

 

[RagDyer]

Try this:

=ROUND(RAND()*(99.99-0.01)+0.01,2)

 

[Dana DeLouis]

numbers that are between $0.01 and $99.99.

"=RANDBETWEEN(1,99)/100 + RANDBETWEEN(1,99)".

I may be wrong, but it appears that your equation gives a minimum value
of 1 +.01 (=1.01) vs your stated 0.01.

How about a slight change to your equation?

=RANDBETWEEN(1,9999)/100

= = = =
HTH :>)
Dana DeLouis

 

[Bob Arnett]

Thanks, both formulas work perfectly but I do prefer the
"=RANDBETWEEN(1,9999)/100".