• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 548
  • Last Modified:

Rounding 0.125 to 0.13 !

Hi,

I am using the Math.Round function to round my values to two decimal places but when I use the value 0.125 it gets rounded to 0.12 and not 0.13 which is what I require.

This adheres to the docs quite happily but not what I want!

"The number nearest d with precision equal to decimals. If d is halfway between two numbers, one of which is even and the other odd, then the even number is returned. If the precision of d is less than decimals, then d is returned unchanged."

I have also tried Decimal.Round to no avail.

Any thoughts?

Many thanks.

James.
0
JAMES
Asked:
JAMES
  • 6
  • 3
  • 3
  • +2
1 Solution
 
aschotsCommented:
if you multiply by 100 then use the ceil function and divide by 100 you should get what you want
0
 
JAMESAuthor Commented:
I have seen answers like that already but wont the ceiling ALWAYS round up!

I need 0.124 still to be 0.12.
0
 
vishwadhCommented:
Use decimal.Round(.0125,2)

It will give you the perfect answer 0.13
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
lucky_jamesCommented:
if the ceiling function is not helping you then perhaps you need to code your own function.

change it into a string.
loop into it and start from back.
Inside loop you can convert the currently pointed character to int


here yop can put your own custom conditions into th loop.


Hope this helps.
0
 
JAMESAuthor Commented:
lucky_james,

With all respect - yuck! ;-)
0
 
aschotsCommented:
You could always write your own rounding function that does exactly what you want.
0
 
answer_meCommented:
check this:
double x = (double)0.125;
            double y = Math.Round(x,2,MidpointRounding.AwayFromZero);
0
 
vishwadhCommented:
did you try decimal.Round(.0125,2)

It will give you the perfect answer 0.13

It works fine for me.
0
 
JAMESAuthor Commented:
vishwadh,

Not for me (this is in VS2003.  I havent tried it in VS2005 yet).

decimal d = 0.125M;
MessageBox.Show(Decimal.Round(d,2).ToString());

Gives 0.12
0
 
JAMESAuthor Commented:
answer_me,

I dont think that overload is available in VS2003 (where this project currently is).

:-(
0
 
answer_meCommented:
use this in 2003 for two decimal places
decimal x=0.125M;
string str= x.ToString("#.##");
0
 
aschotsCommented:
something like :
x = (0.125 *100) mod 1
if (x div 0.5 =0) then floor else ceil
0
 
JAMESAuthor Commented:
answer_me,

What an interesting solution.  I wonder why that works!!??

aschots,

Just about to test yours.
0
 
JAMESAuthor Commented:
answer_me,

Great stuff - well deserved points.

aschots - thanks for your help throughout but im going with answer_me's answer - just feels "cleaner" in a dirty sort of way!

Thanks all.

James.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 6
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now