randbetween function

[sutho]

I am a teacher and use the randbetween function to generate maths worksheets. I am trying to do the same thing with money, eg. $256.57, but I keep getting the amount rounded to the whole dollar, eg. $256.00.
Is there a way I can get random dollars and cents amounts?

 

[T. Valko]

I am a teacher and use the randbetween function to generate maths worksheets. I am trying to do the same thing with money, eg. $256.57, but I keep getting the amount rounded to the whole dollar, eg. $256.00.
Is there a way I can get random dollars and cents amounts?

Try something like this...

=RANDBETWEEN(1,500)/100

 

[sutho]

Biff thank you very much that solved my problem.

 

[T. Valko]

Biff thank you very much that solved my problem.

You're welcome. Thanks for the feedback!