Rounding negative numbers

[mjones74]

I need a formula to round up (including negatives) to the nearest 1/8. I have used round, but it doesn't seem to work with a negative number. Does anyone know a work around?

 

[Scott Huish]

=-int(-a1*8)/8

 

[mjones74]

Thanks I will give that a try.

 

[mjones74]

Okay, now what if I want it to round down to the nearest 1/8. A negative number again.

 

[Rick Rothstein]

Okay, now what if I want it to round down to the nearest 1/8. A negative number again.

It looks to me like you just remove the minus signs...

=INT(A1*8)/8

 

[mjones74]

YES!!! It works. Thank you so much.