| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
