Rounding down nearest 00

[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

 

[Bob Phillips]

=ROUND(A1,2)

--
HTH

Bob

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

 

[Niek Otten]

=ROUNDDOWN(A1,2)

 

[DILipandey]

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

 

[Bob Phillips]

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)

 

[Beeo]

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!

 

[Niek Otten]

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!

 

[Beeo]

Thanks a thousand times - terrific
Tread closed

Beeo