Originally Posted by Bruce Bowler

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