View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Potaroo Potaroo is offline
external usenet poster
 
Posts: 6
Default Rounding up and or down formula

I'm after a formula that will give me the closest to a 0.25 incremental
ending.
That is if the sum ends up being 4.29, I need it to return a 4.25
If it ends up being 2.8 I need it ot return a 2.75.
If it ends up being 2.89 I need it ot return a 3.
Is there such a method?
TIA to all you Gurus.
Pete