Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |