You gave a limited example, but if you want to get to the nearest 10 cents:

? application.Round(1.17,1)
1.2

so
=round(D28/L3+L35,1)

and format the cell for two decimal places.

--
Regards,
Tom Ogilvy


"Chev320" wrote:

I know this is a simple one for you guys, but i just cant see it..
My dollar amount equals $1.17 and i want to round up to 1.20.
I have tried Ceiling & round & roundup with no luck..

=D28/L3+L35 (this is my formula so far)

Thanks