View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
XL 411 XL 411 is offline
external usenet poster
 
Posts: 1
Default I need help with a Function

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