# a problem with rounding

#### almouchie

##### Board Regular
salam
i have total amounts &i want toround them as follows & i have this formula but its not working when the numbers arein tens of thousands or millions
=Round(A1,3-Len(Int(A1)))
i want this outcome
85,735 86,000
85,250 85,000
79,756 80,000
101,300 101,000
482,259 482,000
1,285,750 1,286,000

but its giving me this

85,735 85,700
85,250 85,300
79,756 79,800
101,300 101,000(correct)
482,259 482,000 (correct)
1,285,750 1,290,000

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Try...

=ROUND(A1,-3)

Hope this helps!

thankz it worked

what does the -3 mean exactly so that it worked

much appreciated

almouchie said:
thankz it worked

what does the -3 mean exactly so that it worked

much appreciated

It specifies the 'number of digits' for which to round a number. In this case, since the 'number of digits' specified is a negative one, the number is rounded three digits to the left of the decimal point. If the 'number of digits' is a positive one, such as 3, the number is rounded three digits to the right of the decimal. And lastly, if it's 0, the number is rounded to the nearest whole number.

Hope this helps!

thanks a lot
makes a lot of sense now

Replies
1
Views
2K
Replies
11
Views
2K
Replies
3
Views
796
Replies
8
Views
7K
Replies
0
Views
1K

1,203,318
Messages
6,054,712
Members
444,743
Latest member
johncon60

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back