how do I write a formula to round up a number?

I want to write a formula that will allow me to multiply a currency number by
9 and then round the number up so that it ends in 9. For example, $56.50 x 9
= $508.50 and then round it up to be $509 (no decimals needed). Thanks so
much for your help.

Try:

=ROUNDUP(A1*9+1,-1)-1

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I want to write a formula that will allow me to multiply
a currency number by
>9 and then round the number up so that it ends in 9.
For example, $56.50 x 9
>= $508.50 and then round it up to be $509 (no decimals
needed). Thanks so
>much for your help.
>.
>

Try this on for size:

=CEILING(A1*9,10)-1

Regards,
Ron

"Jason Morin" wrote:

> Try:
>
> =ROUNDUP(A1*9+1,-1)-1
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >I want to write a formula that will allow me to multiply
> a currency number by
> >9 and then round the number up so that it ends in 9.
> For example, $56.50 x 9
> >= $508.50 and then round it up to be $509 (no decimals
> needed). Thanks so
> >much for your help.
> >.
> >
>

Hi Jason,

Works great... You rock! You have saved us so much time and eliminated a
lot of angst.

Barbie & Andrea

"Jason Morin" wrote:

> Try:
>
> =ROUNDUP(A1*9+1,-1)-1
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >I want to write a formula that will allow me to multiply
> a currency number by
> >9 and then round the number up so that it ends in 9.
> For example, $56.50 x 9
> >= $508.50 and then round it up to be $509 (no decimals
> needed). Thanks so
> >much for your help.
> >.
> >
>