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
If the Didgit You're Rounding Is The Number 0-4 you round down to the nearest whole number ending in 0 if the number was 5-9 You would Round Up to the nearest whole Number ending in 0.
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.
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.
It is 77 because you round 5 to 0, and round 6 to 7.
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