View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Bill Ridgeway Bill Ridgeway is offline
external usenet poster
 
Posts: 268
Default Rounding up and or down formula

I have put together and attached a small (14Kb) spreadsheet demonstrating a
range of roundings which may be required.

Regards.

Bill Ridgeway
Computer Solutions

"Potaroo" wrote in message
...
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