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.

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.

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.

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.