Round Currency Closest to Five

Round currency closest to five

Turns out..it's really simple

let x: Float = 1.03 //or whatever value, you can also use the Double type
let y = round(x * 20) / 20

SQL money round to closest 0.05 cents

SELECT ROUND(140.77/5,2) * 5;
+-----------------------+
| ROUND(140.77/5,2) * 5 |
+-----------------------+
|                140.75 |
+-----------------------+

Round to nearest 5 in SQL Server

select round(FineAmount*2,-1)/2 from tickets

or to put nicholaides suggestion in sql

select round(FineAmount/5,0)*5 from tickets

The example assumes that FineAmount is of type money.
The second approach is probably better as the first one works with the limit of maximum_value_of_money_type/2

More on ROUND

Rounding to multiples of 5

You could write it this way:

int roundTo5(int value)
{
    return ((value + 2) / 5) * 5;
}

This takes any forint value, adds 2 and divides by 5. This makes a "floor rounding" of integers and multiplies 5 again.

0 → 2 → 0 → 0
1 → 3 → 0 → 0
2 → 4 → 0 → 0
3 → 5 → 1 → 5
4 → 6 → 1 → 5
5 → 7 → 1 → 5
6 → 8 → 1 → 5
7 → 9 → 1 → 5
8 → 10 → 2 → 10
9 → 11 → 2 → 10

Round to nearest 5 up C#

To always round up, you should use Math.Ceiling instead of Math.Round:

static int RoundUpToMultipleOf5(decimal value) => (int)Math.Ceiling(value / 5) * 5

Rounding up to the nearest 0.05 in JavaScript

Multiply by 20, then divide by 20:

(Math.ceil(number*20)/20).toFixed(2)

Round up to nearest multiple of five in PHP

This can be accomplished in a number of ways, depending on your preferred rounding convention:

1. Round to the next multiple of 5, exclude the current number

Behaviour: 50 outputs 55, 52 outputs 55

function roundUpToAny($n,$x=5) {
    return round(($n+$x/2)/$x)*$x;
}

2. Round to the nearest multiple of 5, include the current number

Behaviour: 50 outputs 50, 52 outputs 55, 50.25 outputs 50

function roundUpToAny($n,$x=5) {
    return (round($n)%$x === 0) ? round($n) : round(($n+$x/2)/$x)*$x;
}

3. Round up to an integer, then to the nearest multiple of 5

Behaviour: 50 outputs 50, 52 outputs 55, 50.25 outputs 55

function roundUpToAny($n,$x=5) {
    return (ceil($n)%$x === 0) ? ceil($n) : round(($n+$x/2)/$x)*$x;
}

Round to nearest 0.05 using Python

def round_to(n, precision):
    correction = 0.5 if n >= 0 else -0.5
    return int( n/precision+correction ) * precision

def round_to_05(n):
    return round_to(n, 0.05)

How would you round up or down a Float to nearest even numbered integer in Swift 3?

If you want to round to the nearest even number, divide by 2, round and then multiply by 2:

let rounded = Int(round(value / 2.0)) * 2

---

Related Topics