Prev: Refernce other files and auto update info
Next: User form
From: sruarg on 13 Jan 2010 16:13
i would like to round a currency amount to the next $ 0.05 (five cents)

eg 30.63 to be 30.65 or 40.48 to be 40.50
From: מיכאל (מיקי) אבידן on 13 Jan 2010 16:24
Try using the CEILING Function.
Micky


"sruarg" wrote:

> i would like to round a currency amount to the next $ 0.05 (five cents)
>
> eg 30.63 to be 30.65 or 40.48 to be 40.50
From: Jeff Jensen on 13 Jan 2010 16:29
Next five cents:
=ROUNDUP(A1/0.05,0)*0.05

Nearest five cents:
=ROUND(A1/0.05,0)*0.05

"sruarg" wrote:

> i would like to round a currency amount to the next $ 0.05 (five cents)
>
> eg 30.63 to be 30.65 or 40.48 to be 40.50
From: Lars-�ke Aspelin on 13 Jan 2010 16:30
On Wed, 13 Jan 2010 13:13:01 -0800, sruarg
<sruarg(a)discussions.microsoft.com> wrote:

>i would like to round a currency amount to the next $ 0.05 (five cents)
>
>eg 30.63 to be 30.65 or 40.48 to be 40.50

Try this formula:

=MROUND(A1+0.2499, 0.05)

Hope this helps / Lars-�ke
From: Jeff Jensen on 13 Jan 2010 16:36
I forgot something...

Next five cents:
=ROUNDUP(A1/0.05,0)*0.05
=CEILING(A1,0.05)

Nearest five cents:
=ROUND(A1/0.05,0)*0.05

"Jeff Jensen" wrote:

> Next five cents:
> =ROUNDUP(A1/0.05,0)*0.05
>
> Nearest five cents:
> =ROUND(A1/0.05,0)*0.05
>
> "sruarg" wrote:
>
> > i would like to round a currency amount to the next $ 0.05 (five cents)
> >
> > eg 30.63 to be 30.65 or 40.48 to be 40.50
 | 
Pages: 1
Prev: Refernce other files and auto update info
Next: User form