ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Rounding dollar amounts to the 9 cents (https://www.excelbanter.com/excel-discussion-misc-queries/448234-rounding-dollar-amounts-9-cents.html)

SugarMagnolia
Rounding dollar amounts to the 9 cents
 
I have a column of dollar amounts that I need to round up or down so that every amount ends in a nine (ex: $23.43 becomes $23.39 and $56.77 becomes $56.79). Is there any way to do this? Thanks in advance.

Bruce Bowler
Rounding dollar amounts to the 9 cents
 
On Fri, 22 Feb 2013 17:12:49 +0000, SugarMagnolia wrote:

I have a column of dollar amounts that I need to round up or down so
that every amount ends in a nine (ex: $23.43 becomes $23.39 and $56.77
becomes $56.79). Is there any way to do this? Thanks in advance.

Does this do it? (assumes value is in a1)

=round(a1,1)-.01

shanermuls
Quote:
Originally Posted by Bruce Bowler (Post 1609646)
On Fri, 22 Feb 2013 17:12:49 +0000, SugarMagnolia wrote:

I have a column of dollar amounts that I need to round up or down so
that every amount ends in a nine (ex: $23.43 becomes $23.39 and $56.77
becomes $56.79). Is there any way to do this? Thanks in advance.

Does this do it? (assumes value is in a1)

=round(a1,1)-.01
=+ROUND(H34+0.01, 1) - 0.01


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com