[jrwebguy]

Hello, Here in canada we decided to remove the penny(1 cents)...HURRAY

Anyway so now all transaction must be rounded up or down (lets say for now just round up) to either

ex. 25.24 rounded up will become 25.25
ex. 14.27 rounded up will become 14.30
ex. 15.22 round up will become 15.25

can anyone help me with this..Im having a hard time doing the math logic to get this result.
any help will be good..thanks

[maj3091]

have a look at the Round function, should do what you want.

I just re-read your post, and I think my suggestion won't work, as I misunderstood it a little. You're working out for currency, hence rounding to the nearest coinage value.

This post has been edited by maj3091: 07 March 2013 - 11:01 AM

[modi123_1]

... you just round to the nearest larger 5 cent area. If anything you can drolly do it by a for loop. Given your current cents check if the number mod 5 is 0.. if so then you don't need to round. If it doesn't then increment your number, checking after each increment if the current number mod five is zero. Stop when you do.

[Atli]

Hey.

Assuming we have the cent count as x, I suppose the algorithm could look like:

IF x % 5 != 0:
    x += 5 - (x % 5)

That is, if the remainder of x divided by 5 is not 0, then add 5 minus said remainder to x, to make it dividable by 5 again.

So:

24 + (5 - 4) == 25
27 + (5 - 2) == 30
22 + (5 - 2) == 25

See what I mean?

[jrwebguy]

thanks for all the reply

[maj3091]

Atli, on 07 March 2013 - 05:58 PM, said:

Hey.

Assuming we have the cent count as x, I suppose the algorithm could look like:

IF x % 5 != 0:
    x += 5 - (x % 5)

That is, if the remainder of x divided by 5 is not 0, then add 5 minus said remainder to x, to make it dividable by 5 again.

So:

24 + (5 - 4) == 25
27 + (5 - 2) == 30
22 + (5 - 2) == 25

See what I mean?

Boy was I over thinking this one..... time to rest my head....

[BobRodes]

Or in VB with one line: (x * 100 - Iif(x * 100 mod 5 = 0, 0, x * 100 mod 5 + 5)) / 100 will round x up to the next nickel.

Of course, the OP was probably trying to simplify by saying to start with always rounding up. It's much simpler to round to the nearest nickel using the round function, so:

Round(x / 5, 2) * 5

This will round the way you want, jrwebguy. (By the way, if you had googled "round to nearest 5" you would have found this right away.)

This post has been edited by BobRodes: 07 March 2013 - 08:06 PM