Hi,
I am making a program that calculates prices from somewhere like a supermarket and need to be able to calculate prices. I would like it to be able to round to 5 cents (as that is our currency in Australia). I have so far got it to round to the 5c, but it is always rounding down. so if the total came to $1.99, the rounded total would come out as $1.95.

This is the code I have so far

All I need is for it to round up or down depending on what the price is.
Thanks
-jimmy

This post has been edited by Jimmy89: Jul 5 2007, 10:46 AM

Well first you need to decide if you want to actually round it, or just drop it to the 0.05 below it. What I mean is, normally 1.99 would round to $2.00 not $1.95 if rounding to the nearest 5 cents

Past that, personally my method would be to do something along the lines of taking the value, in cents, and modding by 5. If the remainder (value after modding) is 0, 1, or 2, return the value minus that remainder (dropping 1.92 for example to 1.90) or if it is 3 or 4, it could return the value plus 5 minus the remainder (bringing 1.93 to 1.95, for example).

I hope that makes sense as I just got to work so don't have the time to put it into actual code form

Here is some sample code as what Jeigh had suggested. The only thing you need to take note of is that mod only works for integer, so you need to scale up the currency by 100, then scale down later

That should do it. I didn't code it in visual studio, if you see syntax error, you should know what to do. The concept is there.

Good Luck

with the new code, when the value gets to say $1.94, it rounds it back to $1.91 and when it gets to $1.99, it rounds to $1.96. Both of those don't work, but everything else rounds perfectly

Sorry, i made a mistake. it should be
result += 5

Thanks heaps! Works perfectly!
-jimmy

Awesome, thanks for throwing that into code form faulty, mine woulda been pseudo-code anyways since I haven't used strict vb in awhile haha. Good stuff

Oh and its not like I mind, but just curious, is this for homework? hah

well, last year as part of our programming course, we made a simple program (this was way back at the start) that calculated numbers in a textbox. We then, in class, adapted it to a kind of Point-of-sale program, which had its flaws. Recently, i was going over the old archives of work looking for something and found the project. So this was just trying to update it a bit!
-jimmy

This post has been edited by Jimmy89: Jul 6 2007, 06:47 AM

Oh cool, yea it's not like I cared about helping someone on homework, it just had a real computer-science-assignmenty feel to the question so figured I'd ask my curiosity always gets the best of me so I dont bother fighting it anymore.

Well, In some ways you were right! It was originally from an assignment! And whoever said that curiosity killed the cat, i say the cat should have been more careful!