Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Thanks fellas for your input in helping me out.
You fellas and all the others who help people with their problems are indisensible to blokes like me. Regards Pete "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding Down Formula | Excel Worksheet Functions | |||
Rounding up Formula | Excel Worksheet Functions | |||
rounding a formula with sum | Excel Discussion (Misc queries) | |||
Rounding with the sum formula | Excel Discussion (Misc queries) | |||
rounding formula | Excel Worksheet Functions |