Round up/down to the nearest 2.5

Question

Level 1

6 points

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.

Posted on Nov 17, 2024 4:17 AM

Reply

Answer 1

Level 7

21,551 points

Hi R.M.P.,

The MROUND function is your friend.

Formula in C2 is MROUND(B2,2.5)

Fill down.

Regards,

Ian.

Reply

Answer 2

Level 1

6 points

Awesome, thank you Ian 😁

(Don't suppose you know how to change my username too?)

Reply

Answer 3

Level 7

21,551 points

R.M.P. wrote:

(Don't suppose you know how to change my username too?)

I have alerted our Hosts.

Regards,

Ian.

Reply

Quick Links