First you determine the number of significant figures, or the amount of digits valid to what you are calculating.
Second you chose one digit farther and determine if that number is
a. less then 5
b. 5
c. greater then 5
If (a) then you round "down" to one digit less
If (b) or (c) then you round "up" adding one to the preceding digit
EX rounded to the hundredths place:
2.3333 (a) --> 2.33
2.3555 (b) --> 2.36
2.3381 (c) --> 2.34
Rounding to 0 can occur depending on where you're rounding to:
4.9 --> 5.0
3.29 --> 3.30
You would round the nine up, which will round the next nine up, which will round the 0 up. So you will be left with 1.
125 rounds to 0 which is 0 thousand, if you like.
To round 1055 to the nearest 1000, we look at the hundreds place, which is 0 in this case. Since 0 is less than 5, we round down. Therefore, 1055 rounded to the nearest 1000 is 1000.
To round 4.80 to the nearest ten dollars, we look at the digit in the tens place, which is 0. Since 0 is less than 5, we round down. Therefore, 4.80 rounded to the nearest ten dollars is $0.
The 1 is in the thousands place and the place before is 0. Generally you should use the rule 5 and above, round up, 4 and below round down. In this case, 0 is less than 4, so you should round down to the nearest thousands place.
you should round to 0
0
0
15 round 5 0-4 round down 5-9 round up
0
Try this, substitute B2 and A2 with the cells you are trying to round =(ROUND(B2*96, 0)/96)-(ROUND(A2*96, 0)/96)
0
0
It is 0 0.00005
The ISBN of Skinner's Round is 0-7472-5041-3.
The ISBN of The World Is Round is 0-345-27213-7.
It is 0