Rounding in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top