Rounding to nearest 1/8

S

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
 
S

Spiketrip

Utilize Floor to round down to the nearest .125

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