Hi,

I've got a vexing situation when using the mround function. I am utilizing the following formula:

=mround(average(g$2:g$4),0.05)

and receiving "#num" error messages. After trouble-shooting extensively, it appears that the formula works when the result is a positive number; it brings up the "#num" error message when the result is a negative number.

This seems to me to be retarded. How is it that Excel cannot deal with negative numbers? Is my version buggy, or does someone know a fix within the syntax of the formula? All help will be mucho appreciado.