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
|