round the numbers

[newmemeber123]

hello,

i have integer number which is variable 0.869231 and i want to round it nearest number after two decimal points such as 0.869231 should be 0.87 if it is 0.986858  the it should be 0.99.. how can i do it?

thank you 

[GerdW]

Hi new,

---

@newmemeber123 wrote:

i have integer number which is variable 0.869231 and i want to round it nearest number after two decimal points such as 0.869231 should be 0.87 if it is 0.986858  the it should be 0.99.. how can i do it?

---

So you have float numbers like 0.8692? And you want to round them to 2 significant digits?

Do you want to round them just for display purposes (see item 1) or do you want to use the rounded values later on for other calculations (see item 2)?

1. Set the display format to %.2f of your numeric indicators…
2. Multiply by 100, round to nearest integer, divide by 100. Keep in mind there will be rounding issues for the "divide by 100" operation as there are rounding issues for nearly all floting point operations…

[crossrulz · Accepted solution]

Multiply by 100, round to nearest integer, divide by 100.

[JÞB]

First, you have a floating point number.  Integers are whole numbers 0, 1, 2, 3...

Multiply by 100, (or 10^nth where n is the number of places after the decimal point) round then divide by 100 (or 10^nth.)

Edit: I guess I type slow

[billko]

Just wanted to add that if you just wanted to compare two numbers (like a test result to a requirement specified to two decimal places), you can do the multiplication,as in the previous posts, for both the result and the requirement, round each to the nearest integer and then do your comparison.  This will avoid floating point issues.