MROUND Question

legalk

New Member
Joined
Nov 22, 2005
Messages
20
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

Well-known Member
Joined
Sep 15, 2004
Messages
696
Hello and welcome to the board,

You can use:
Code:
=FLOOR(123,25)
 

Forum statistics

Threads
1,078,117
Messages
5,338,314
Members
399,226
Latest member
arictarhvasiliev

Some videos you may like

This Week's Hot Topics

Top