Using EXCEL to solve problems using random numbers

So, I have this problem:

By using random numbers, it is possible to eliminate the need for change and give the store and the customer a fair deal. This problem indicates how it could be done.

1. Suppose that you buy something for $0.20. How could you use random numbers (built into the register system) to decide wether you should pay $1.00 or nothing?
2. If you bought something for $9.60, how would you use random numbers to eliminate the need for change?

I know these are "basic" problems, but I've not used EXCEL for this purpose before. We just started using the palisade suite if that helps.


Thanks in advance.
-Frustrated student

Originally Posted by MarvinP

Hi Mooselogger and welcome to the forum,

See if the attached example meets your needs.

Attachment 545345

Hi Marvin.

That is what I needed. Thank you!

-Andreas