|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
I need help with a Function
=ROUNDUP(A1/12,0)*12
"XL 411" wrote:
Here is what I got:
F24 = 64
F25 = 12
on cell F26 I got the function =MROUND(F24, F25) which gives me 60.
Basically the formula is rounding 64 to the nearest multiple of 12, which
it"s 60. But what I want is for a formula to roundup to the nearest multiple
of 12. In other words I want the outcome to be 72. Can anybody out there help
me with this issue. If you have an answer please send me an e-mail to
. Thank you for the time
|