knobz wrote:
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.

Hi knobz

If you use Bearacade's functions you may need to add the Analysis
ToolPak:

Tools Add-Ins check the Analysis ToolPak checkbox

Regards

Steve