| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rounding
When using MRound (Or floor/Ceiling) Is there a seperate function for
negative. Meaning I have a column with positive numbers and negative numbers which I need rounded to the nearest 1/8th. Do I have to first do an IF to see if its + then do an Mround (a1,.125) and if its - then Mround (a1,-.125) ? Thanks. |
|
#2
|
|||
|
|||
|
You can use
=MROUND(A1, SIGN(A1)*(1/8)) HTH Kostis Vezerides "ynissel" wrote in message ... When using MRound (Or floor/Ceiling) Is there a seperate function for negative. Meaning I have a column with positive numbers and negative numbers which I need rounded to the nearest 1/8th. Do I have to first do an IF to see if its + then do an Mround (a1,.125) and if its - then Mround (a1,-.125) ? Thanks. |
|
#3
|
|||
|
|||
|
Perfect - thanks !!
"Kostis Vezeridis" wrote: You can use =MROUND(A1, SIGN(A1)*(1/8)) HTH Kostis Vezerides "ynissel" wrote in message ... When using MRound (Or floor/Ceiling) Is there a seperate function for negative. Meaning I have a column with positive numbers and negative numbers which I need rounded to the nearest 1/8th. Do I have to first do an IF to see if its + then do an Mround (a1,.125) and if its - then Mround (a1,-.125) ? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding | Excel Discussion (Misc queries) | |||
| Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
| rounding | Excel Worksheet Functions | |||
Linear Mode
