Rounding down nearest 00

  • Thread starter Thread starter beeo
  • Start date Start date
B

beeo

Hi

I have to following values in a column

10.344
9.877
15.982
etc

I want to round down to nearest 00 zeros

10.340
9.870
15.980

Can this be done? Thanks for all your help
 
=ROUND(A1,2)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi..

Futher to what Niek has answered, you can use the following to get the
training zero as well.

=TEXT(ROUNDDOWN(A1,2),"#.000")

but obviously, if you it is going to be as Text because you need zero at the
end after decimal, which a number can not have.

Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
You can get it by just formatting the cell as #,##0.000, no need to make it
text.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thanks for all the suggestion but it it will not solve my problem. If
I refraise the question

A1 B1 C3

USD 27450.00 SUM(A1*1,05) I want the result to
be
= USD 28822,5 USD 28820

Hopefully not too confusing :)
Thanks again!
 
In B1:
=A1*1,05 (no need for SUM)
In C1:

=ROUND(B1,-1)

Or maybe, if you use ; as a list separator:

=ROUND(B1;-1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Thanks for all the suggestion but it it will not solve my problem. If
I refraise the question

A1 B1 C3

USD 27450.00 SUM(A1*1,05) I want the result to
be
= USD 28822,5 USD 28820

Hopefully not too confusing :)
Thanks again!
 
Back
Top