"Rounding" error
Stuart wrote:
Thanks, but I think the chance to Round has passed by the time
the value hits the Sum cell.
I guess I need to find a way to Round each calculation BEFORE
its' result is added to the Sum....if you see what I mean.
Sorry Stuart,
round globally the product this way
.....formularray = SUM(ROUND(array1*array2;roundoff))
Choose the round off you desire.
I tested this formula manually in a worksheeet and Excel allows it.
Let us know.
Alex.
|