I have put together a small (14Kb) spreadsheet demonstrating a range of
roundings which may be required. This can be downloaded from
www.1001solutions.co.uk/rounding.xls
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