John R. Sowden wrote:
I have discovered a difference between 2.4 and previous versions in the way
empty cells are treated in a formula. In prior versions, if a formula was to
add a cell in which there was a space, or a null ("") (two quotes with
nothing inside, the cell was just ignored and the formula went forward to
successful completion. In other words the formula treated the cell as having
a numeric value of zero.
BUT,
with 2.4, the formula fails. This is an issue for me because I don't want
zeros, or a value displayed down to row 750 if there is nothing in the 'Item'
cell, so, in my balance column, I do the following:
=if(c12="";"";f13+d12-e12)
This now fails in all of my sheets.
Help?
John
The formula structure is sound. I suspect that there is a circular
error, where the formula folds back upon itself. Try the formula in a
different cell in a row subsequent to row 13 and see if it still errors
out. I created a spreadsheet with some dummy values in the appropriate
cells, and your formula works in Calc on a WinXP Pro machine w/SP3.
Put your cursor focus on the error cell. Press TOOLS -> DETECTIVE ->
TRACE PRECEDENTS to quickly find out if you have a circular reference
set up.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
