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.
.
|