Rounding decimals 3 places

9 miles
15839 = 8.999431818 miles
1 yard = 0.000568181818182 miles
This really comes down to how you round up and what number of decimal places you round at . at two decimal place you could look at it as equal .
8.999 >> rounded to two decimal places = 9 miles
also is a mile the same number of yards in each country ?

Huh?
To round off a number to 2 decimal places.... you would have to have a decimal. Your number of 3,150,000 implies 3,150,000.00

There is no rounding in this case. It is simply adding a decimal and two zeros after the decimal.

Semper Fi,
Z

There are no decimal digits in this number. You can put a decimal mark in 8 537 000. and append two zeros, or more. But I would not call that rounding 8 537 000.00

Set the display to 2 decimal places then use the [RND] function. See how the manual describes the Round operation.

Brief example:
01- 42 2 [f][2]
02- 42 14 [f][RND]
03- 42 9 [f][9]
The above program takes the number displayed and rounds to 2 decimal places (nearest 100th), then displays all decimal places.
If you entered 2.876 and ran the program, it would display 2.880000000.

There are several different rounding schemes, but by the most common it would be 57.50 and 58.49 .

fastest 57.50, slowest 58.49

CUT: Values are cut off to the number of decimal places speicified by the current Decimal Place Selector setting

UP: Values are rounded up to the number of decimal places speicified by the current Decimal Place Selector setting

5/4: Values are rounded off (0,1,2,3,4 are cut off; 5,6,7,8,9 are rounded up) to the number of decimal places speicified by the current Decimal Place Selector setting

pressing the tab button displays the number of decimal places 0, 2, 3, 4, A, F on the bottom of the screen.

The function is called ROUND. It has 2 arguments, (1) the original number and (2) the number of decimal digits. Here is the Excel's help: ROUND(number,num_digits) The number you want to round. • None. num_digits The number of digits to which you want to round number. • If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. • If num_digits is 0, then number is rounded to the nearest integer. • If num_digits is less than 0, then number is rounded to the left of the decimal point.
So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken