Rounding to nearest 1/8

[Spiketrip]

I am trying to round off numbers to the nearest 1/8 either up or down

ie 41.06-.58=40.48 round down to the nearest 1/8 because it wa
subtraction, answer 40.38 (40.375)

41.06+.48=41.54 round up to nearest 1/8 because it was addition, answe
41.63 (41.625)

Thanks for the help.

Mik

 

[Peo Sjoblom]

1.

=FLOOR(A1-B1,1/8)

2.

=CEILING(A1+B1,1/8)

 

[Spiketrip]

Utilize Floor to round down to the nearest .125

=FLOOR(a7,.125)
=CEILING(a7,.125