Bob, if you are out there I need your assistance once again. you created
this formula for me to have my numbers end in either a 5 or a 9 and it works
great, can this formula be altered to end in either 49 or 99, depending on
where the numbers fall. Example 419 rounded down to 399, 329 rounded down to
299, 339 rounded up to 349, 359 rounded down to 349 or 369 rounded up to 399.
Of couse the numbers will be larger. Any assistance I can get with this
would be great. Thank you.
--
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