[email protected] wrote...
>"Harlan Grove" wrote:
>>[email protected] wrote...
>>>=MROUND($W11-$N11,4*SIGN($W11-$N11))
>>
>>Probably better to change it to
>>=SIGN($W11-$N11)*MROUND(ABS($W11-$N11),4)
>
>I'll bite: why? If there is a difference, please provide an example.
....

Since MROUND(x,0) always returns 0 (which I only just now confirmed), I
suppose your formula with just two function calls would be more
efficient. However, better to eliminate the ATP dependency and use

=4*ROUND(($W11-$N11)/4,0)