a problem with rounding

[almouchie]

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

 

[Domenic]

Try...

=ROUND(A1,-3)

Hope this helps!

 

[almouchie]

thankz it worked

what does the -3 mean exactly so that it worked

much appreciated

 

[Domenic]

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!

 

[almouchie]

thanks a lot
makes a lot of sense now