| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to the Nearest Eighth
I have a problem with rounding down to the nearest eighth. For example: 100.334 and i need it to round to 100.25, I used some of the rounding suggestions found on the forum but it's not the working. I also need the rounding work when it is a negative number. For Example: -.655 it needs to round to -.625. Thanks, L.sean9 -- L.sean9 ------------------------------------------------------------------------ L.sean9's Profile: http://www.excelforum.com/member.php...o&userid=35681 View this thread: http://www.excelforum.com/showthread...hreadid=554767 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to the Nearest Eighth
=mround(a1,0.125) -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=554767 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to the Nearest Eighth
=ROUND(A1*8,0)/8
--ron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to the Nearest Eighth
Here's another Way: With your original figures in Col A for (A1) -- in
B1 enter =IF(A10,FLOOR(A1,0.125),FLOOR(A1,-0.125)) "L.sean9" wrote in message : I have a problem with rounding down to the nearest eighth. For example: 100.334 and i need it to round to 100.25, I used some of the rounding suggestions found on the forum but it's not the working. I also need the rounding work when it is a negative number. For Example: -.655 it needs to round to -.625. Thanks, L.sean9 -- L.sean9 ------------------------------------------------------------------------ L.sean9's Profile: http://www.excelforum.com/member.php...o&userid=35681 View this thread: http://www.excelforum.com/showthread...hreadid=554767 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to the Nearest Eighth
On Thu, 22 Jun 2006 16:10:17 -0500, L.sean9
wrote: I have a problem with rounding down to the nearest eighth. For example: 100.334 and i need it to round to 100.25, I used some of the rounding suggestions found on the forum but it's not the working. I also need the rounding work when it is a negative number. For Example: -.655 it needs to round to -.625. Thanks, L.sean9 I misread. To round down to the nearest eighth, you could use the rounddown function: =ROUNDDOWN(A1*8,0)/8 It gives your specified answers for your two examples. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding Interest to nearest eighth | Excel Discussion (Misc queries) | |||
| rounding to nearest hundred dollar in Excel | New Users to Excel | |||
| Formula for rounding to the nearst eighth of one percent | Excel Worksheet Functions | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Rounding up to the nearest nickel | Excel Discussion (Misc queries) | |||
Hybrid Mode
