Rand Roundup & Custom autofilter

[sythong]

Greetings again.

I am having problem trying to get 2 related problems to work.

1. I want to roundup to the nearest cents (presently I use randbetwen(100,200)
and the result does not show any cents. How do I get it to work to show cents
eg 100.20 and if possible to show it only ending with 0 or 5 because for cash
transactions the common curency is 10, 20 and 50 cents.

2. The other thing that i am grappling (which again is related to the top) with is
I have already generated a set of figures and it has ending cents ranging from
1 to 9. I tried to do a custom autofilter to look for "ends with" and apply any
one of the following, .01,.02,.03,.04,.06,.07,.08,.09 but it does not work.
So I have to walk through every individual cell to change those in that range to
manually change the range to either a .05 or zero where the cents are.

Thanks again for reading

 

[energman58]

If I have understood your problem this will produce numbers up to 100 dollars ending in 0 or 5 cents

=ROUND(RAND()*20,2)*5

If you want a different number just divide the maximum by 5 and use that to replace teh 20 in the above formula if you want it between 100 and 200 dollars then just add 100 to the above formula like this:

=100+ROUND(RAND()*20,2)*5

 

[sythong]

energman58

Thanks so much for the suggestion.

One fell swoop and both are solved!!!

 

[energman58]

You are welcome