Brian Hassard wrote:
MIN under Excel considers blank cells to contain zero data, but
MIN under oocalc ignores blank cells.
Suppose the test grades were 80, 60, (didn't take), and 70.
With Excel, the MIN of the four test grades is 0
and the sum of the three best test grades is 210.
No, MIN is 60 in Excel, too. There is a difference if all cells are
empty (the result is then 0 in Excel, an error in Calc), but from your
description, that doesn't seem to be your problem. There must be
something else in your sheet causing the different result.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
