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.
Question marked as
Hi R.M.P.,
The MROUND function is your friend.
Formula in C2 is MROUND(B2,2.5)
Fill down.
Regards,
Ian.