Posted to microsoft.public.excel.worksheet.functions
|
|
Formula nesting
"Harlan Grove" wrote:
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.
and it's a mystery why MROUND does this
Y'get no argument from me on that one.
|