Prashant Cholachagudda
Prashant Cholachagudda

Reputation: 13090

How to round decimal value up to nearest 0.05 value?

Is there any way to round up decimal value to its nearest 0.05 value in .Net?

Ex:

7.125 -> 7.15

6.66 -> 6.7

If its now available can anyone provide me the algo?

Upvotes: 22

Views: 24142

Answers (5)

Tejasvi Hegde
Tejasvi Hegde

Reputation: 2922

I could not get proper rounding in most of the formulas

This one "rounds" to nearest

float roundFloat(float value, float toNearest) {
            float divVal = (1 / (toNearest == 0 ? 1 : toNearest));
            return ((float)(Math.Round(value * divVal)) / divVal);
        }

Result:

roundFloat(2, 0.125F); -> 2
roundFloat(2.11, 0.125F); -> 2.125
roundFloat(2.22, 0.125F); -> 2.25
roundFloat(2.33, 0.125F); -> 2.375
roundFloat(2.44, 0.125F); -> 2.5
roundFloat(2.549999, 0.125F); -> 2.5
roundFloat(2.659999, 0.125F); -> 2.625
roundFloat(2.769999, 0.125F); -> 2.75
roundFloat(2.879999, 0.125F); -> 2.875
roundFloat(2.989999, 0.125F); -> 3

Example 0.125 nearest rounding

 2.000 
 2.125 
 2.250 
 2.375 
 2.500 
 2.625 
 2.750 
 2.875 
 3.000 

Upvotes: 0

Andriy Volkov
Andriy Volkov

Reputation: 18933

Something like this should work for any step, not just 0.05:

private decimal RoundUp (decimal value, decimal step)
{
    var multiplicand = Math.Ceiling (value / step);
    return step * multiplicand;
}

Upvotes: 7

Adam Bellaire
Adam Bellaire

Reputation: 110539

How about:

Math.Ceiling(myValue * 20) / 20

Upvotes: 32

Marc
Marc

Reputation: 9292

Use this:

Math.Round(mydecimal / 0.05m, 0) * 0.05m;

The same logic can be used in T-SQL:

ROUND(@mydecimal / 0.05, 0) * 0.05

I prefer this approach to the selected answer simply because you can directly see the precision used.

Upvotes: 12

Fredou
Fredou

Reputation: 20140

Math..::.Round Method (Decimal, Int32, MidpointRounding)

Rounds a double-precision floating-point value to the specified number of fractional digits. A parameter specifies how to round the value if it is midway between two other numbers.

   Math.Round(1.489,2,MidpointRounding.AwayFromZero)

Upvotes: 2

Related Questions