Re: rounding

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 08:42:06 +0200

Hi
use
=ROUND(A1*20,0)/20

Also see:
http://www.xldynamic.com/source/xld.Rounding.html#fractions 

--
Regards
Frank Kabel
Frankfurt, Germany
"dodge" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:04b401c4aaa3$97195ef0$a601280a@phx.gbl...
> how do I round a currency value to the nearest 5c. where
> the cell may have a value that may require rounding up or
> down depending on it's value. ie $1.11 to $1.10 or $1.14
> to $1.15.