round off?

  • Thread starter Thread starter Edwin van Weert
  • Start date Start date
E

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
 
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
 
Back
Top