Tom, Multiply by fifty, find the nearest integer, then divide by 50.
((nint((50 * currencycolumn)) / 50) Bill On Mon, Aug 29, 2011 at 5:17 PM, TOM HART <[email protected]> wrote: > Is there a way to round currency to the nearest .50, what I want to do is > round currency the the nearest dollar or .50 > eg > > $1.76 to $2.00 > $1.74 to $1.50 > etc > > Tom Hart > >
