Bob,

I tried it and it worked, but to be honest with you I really don't
understand what or how it is working can you explain for me. This formula is
a bit advanced for me and I would really like to understand it so I can use
it on a large spreadsheet. Also is there anyway to combine the formula you
gave me with the one simple one that I had initially "=D8/0.67". Bob you
are great!!
--
Angie33


"Bob Phillips" wrote:

=CEILING(A10,5)-(AND(MOD(A10,10)<0,MOD(CEILING(A10,5),10)=0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Angie33" wrote in message
...
Does anyone know how to use the Round Function or the Ceiling function to
round up to a specific number? Example: I have the number 1288 in D8 and
I
have a formula in E8 which says "=D8/0.67", the result is 1922. But I
would
like "1922" to round up to "1925". Had it been "1927", I would want it to
round up to 1929. Can anyone tell me how to do this?
--
Angie33