View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ConfusedNHouston ConfusedNHouston is offline
external usenet poster
 
Posts: 41
Default Rounding to Multiples of Integers?

I have a process which involves taking a product of two numbers and then
rounding down to the nearest multiple of five.

Can I write a cell-formula that will ..EITHER .. multiply the two terms AND
round the product to a multiple of five .. OR.. a formula that will take a
single value from a neighboring cell and round it down to the nearest
multiple of five?

Thanks