round off?

[Edwin van Weert]

Hi

Can anyone help me with round off?

Not on round off like 0.5 - 1 and 0.4 =0

What I like to do is:
If I have a value of 100, I like e.g. to take the max amounts of 9 that is
with in this value in this case 99

Or if a value is 3377 $ and I'm allowed to take only 50$ or a multiple times
50$ what is the max that I can take?
In this example 3350$

Can anyone help me with a function for this?

Thanks

Edwin

 

[Jerry W. Lewis]

Given your 3377 example, I assume that you want to truncate rather than
round, in which case
INT(100/9)*9 = 99
INT(3377/50)*50 = 3350

For rounding to a multiple, see the MROUND function in the Analysis ToolPak.

Jerry

 

[Stephen Bye]

That would be
9*INT(100/9)
or
50*INT(3377/50)