Rounding in Excel

[Guest]

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.

 

[Bernard Liengme]

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

 

[Guest]

Try this:

=ROUNDDOWN((A1-B2)/.125,0)*.125

HTH,
Elkar

 

[JE McGimpsey]

one way:

=FLOOR(A1-B2,0.125)