Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding dollar amounts in half dollar increments | Excel Worksheet Functions | |||
Comparing Row by Row - A-D dollar amounts to E dollar amount | Excel Worksheet Functions | |||
Rounding dollar amounts up/down when cents aren't part of the fact | Excel Worksheet Functions | |||
ROUND CENTS TO EITHER 49 OR 99 AMOUNTS | Excel Worksheet Functions | |||
Converting 100 cents to 1 dollar | Excel Worksheet Functions |