You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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.
Awesome, thank you Ian 😁
(Don't suppose you know how to change my username too?)
R.M.P. wrote:
(Don't suppose you know how to change my username too?)
I have alerted our Hosts.
Regards,
Ian.
Round up/down to the nearest 2.5
