Brian Barker wrote:
At 18:20 19/03/2009 -0700, Suzanne L. Perry wrote:
There is a setting at Tools | Options... | OpenOffice.org Calc |
Calculate | Precision as shown. If this is ticked, the displayed
values - rounded according to the cell formatting - are used in your
comparison rather than the actual values stored in the cells. Again,
this setting and your choice of cell formatting may alter the results.
I trust this helps.
Brian Barker
Another possibility, maybe some of the cells have strings of number
characters in them, instead of actual number values.
To check for this, use =COUNT() function to count the number of numbers,
and compare it to the row differences. If they are the same then this
is the wrong explanation.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
