| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
MROUND function. Getting the following error: #NAME?
Hello,
i am trying to round numbers to a a multiple of 5. i am trying to use the MROUND function. But i am having the following error : #NAME? Formula contains unrecognised text |
|
#2
|
|||
|
|||
|
menu ToolsAdd-ins, tick the box next to "Analysis ToolPack" and press OK.
Regard, KL "masoud" wrote in message ... Hello, i am trying to round numbers to a a multiple of 5. i am trying to use the MROUND function. But i am having the following error : #NAME? Formula contains unrecognised text |
|
#3
|
|||
|
|||
|
you could also substutute MROUND with a standard function, e.g.:
=MROUND(A1,50) equals =ROUND(A1/50,0)*50 Regards, KL "masoud" wrote in message ... Hello, i am trying to round numbers to a a multiple of 5. i am trying to use the MROUND function. But i am having the following error : #NAME? Formula contains unrecognised text |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Date & Time | New Users to Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| MROUND function disappears | Excel Discussion (Misc queries) | |||
Linear Mode
