MROUND Question

[legalk]

Hi Guys

I hope someone can help.

I have a number that is 123 and I was to round that to the nearest 25 - BUT NOT more than the initial 123 - so in this case is should be 100.

Does anyone have any advice - I am currently using MROUND but it does round over the initial amount, and I have looked all over the place.

Many Thanks

Ken.

 

[a7n9]

Hello and welcome to the board,

You can use:

=FLOOR(123,25)