Thread: Formula nesting
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default Formula nesting
wrote...
"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.
....

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)

Reply With QuoteReply With Quote