Bill,
I tried 7.46 and it returned 7.4, but I want 7.5
Tom
________________________________
From: Bill Downall <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Mon, August 29, 2011 4:59:29 PM
Subject: [RBASE-L] - Re: Rounding
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
>
>
