Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MRound | Excel Programming | |||
MROUND | Excel Discussion (Misc queries) | |||
MROUND | Excel Discussion (Misc queries) | |||
MROUND | Excel Discussion (Misc queries) | |||
Mround | Excel Discussion (Misc queries) |