MROUND Help
 

I have the following formula:
=MROUND($AV15*$BG$5,50)

I now would like to modify it such that the lowest value for the
multiple is 50 or, if the result of 50/J15 is not an integer, then I
want to substitute 50 by the closest rounded up integer value that
divides into J15. The minimum value for the multiple has to be 50.

Examples:
* If J15 is 10 then the formula is =MROUND($AV15*$BG$5,50) because
50/J15 is an integer and 50 is my minimum multiple,
* If J15 is 30 then the formula is =MROUND($AV15*$BG$5,60) because
50/J15 is not an integer and the closes integer (rounded up) that
evenly divides into J15 is 60.

I hope I explained it clearly enough...

Thanks in advance for your help!
--
tb

MROUND Help
 

Try:
=MROUND($AV15*$BG$5,MIN($AV15,50)*CEILING(50/$AV15,1))



On Thu, 15 Aug 2013 15:20:49 +0000 (UTC), "tb"
wrote:

I have the following formula:
=MROUND($AV15*$BG$5,50)

I now would like to modify it such that the lowest value for the
multiple is 50 or, if the result of 50/J15 is not an integer, then I
want to substitute 50 by the closest rounded up integer value that
divides into J15. The minimum value for the multiple has to be 50.

Examples:
* If J15 is 10 then the formula is =MROUND($AV15*$BG$5,50) because
50/J15 is an integer and 50 is my minimum multiple,
* If J15 is 30 then the formula is =MROUND($AV15*$BG$5,60) because
50/J15 is not an integer and the closes integer (rounded up) that
evenly divides into J15 is 60.

I hope I explained it clearly enough...

Thanks in advance for your help!