Hi,
I need some assitant with rounding to the nearest 1/8. I used =mround(a1,0)*0.125. It does round but I need the formula to round if it is negative. For example.
-1.335 = -1.25
-1.449= -1.375
-1.502=-1.5
Any Help!!!!!!!!!!!!
Thanks,
Sean
Hi,
I need some assitant with rounding to the nearest 1/8. I used =mround(a1,0)*0.125. It does round but I need the formula to round if it is negative. For example.
-1.335 = -1.25
-1.449= -1.375
-1.502=-1.5
Any Help!!!!!!!!!!!!
Thanks,
Sean
=TRUNC(A1 * 8) / 8
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks