Roundup or Ceiling Function to round to a specific number
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
|