I need to round numbers to the nearest ZERO or FIVE. Both Positive and
Negative. I am using the formula "=ROUND(Q89,1-LEN(INT(Q89))". it does it
mostly fine with postive number except 25 gets rouned to 30.. any way of
keeping 25 at 25.. and also negative numbers don't work. the cell is blank.
not even an error.