Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding in Excel
I ave read many publications on rounding, but can't get an answer. I know how
to round a given cell. How do you round the result of an equation to the lowest eigth? In other words, =sum(a1-b2), where a1 is = to 3.75 and b2 is = ..05 , result (3.70), but the result should be rounded down to the next lowest 1/8th? 3.625 in the equation shown. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding in Excel
Firstly, it I want A1-B1 I do not need the SUM function, I can use just
=A1-B1 Secondly, to round to a fraction (1/N) we multiple by N, round to zero decimals and divide by N You asked for round down, so use =ROUNDDOWN((A1-B1)*8,0)/8 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Jday" wrote in message ... I ave read many publications on rounding, but can't get an answer. I know how to round a given cell. How do you round the result of an equation to the lowest eigth? In other words, =sum(a1-b2), where a1 is = to 3.75 and b2 is = .05 , result (3.70), but the result should be rounded down to the next lowest 1/8th? 3.625 in the equation shown. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding in Excel
Try this:
=ROUNDDOWN((A1-B2)/.125,0)*.125 HTH, Elkar "Jday" wrote: I ave read many publications on rounding, but can't get an answer. I know how to round a given cell. How do you round the result of an equation to the lowest eigth? In other words, =sum(a1-b2), where a1 is = to 3.75 and b2 is = .05 , result (3.70), but the result should be rounded down to the next lowest 1/8th? 3.625 in the equation shown. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding in Excel
one way:
=FLOOR(A1-B2,0.125) In article , Jday wrote: I ave read many publications on rounding, but can't get an answer. I know how to round a given cell. How do you round the result of an equation to the lowest eigth? In other words, =sum(a1-b2), where a1 is = to 3.75 and b2 is = .05 , result (3.70), but the result should be rounded down to the next lowest 1/8th? 3.625 in the equation shown. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I stop excel from rounding numbers? | Excel Discussion (Misc queries) | |||
How do I record (.468) time in Excel without it rounding to .5? | Excel Discussion (Misc queries) | |||
stop excel from rounding a result | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |