Round up/down to the nearest 2.5
I wish to be able to round up/down to the nearest 2.5 in the same cell. For example:
80.9 rounding down to 80.0
82.1 rounding up to 82.5
86.6 rounding up to 87.5
88.2 rounding down to 87.5
etc.
Hi R.M.P.,
The MROUND function is your friend.
Formula in C2 is MROUND(B2,2.5)
Fill down.
Regards,
Ian.