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.
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

a7n9

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

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

Watch MrExcel Video

Forum statistics

Threads
1,118,062
Messages
5,569,981
Members
412,301
Latest member
excelmaps
Top