Excel ISNUMBER question

H

Howard Brazee

I have some spreadsheets that I want to be mostly blank, until I
populate this row.

So each cell starts off with
=IF(ISNUMBER(

I'm getting two problems here:

1. I get circular references with my multiple page spreadsheet. I've
got too many formulae that depend upon me being finished with a
multiple page row, and too many "wait until this is populated to go".

I'm looking for a "best practice" way of controlling such a multiple
page row.

2. Sometimes I see a cell such as:
=IF(ISNUMBER(J11),J11+T11,"")

that has a 0 in it even though J11 has a formula that calculates to 65
and T11 has a formula that calculates to 55.

Or
=IF(ISNUMBER(+ESC!U11),"")

where ESC!U11 points to a formula that calculates to 0, but I get
space.

I'm thinking ISNUMBER isn't the best way to do this spreadsheet, but
don't know what way works better.
 
B

Bob I

Almost sounds like the sheet has not be recalculated. Also have you
considered testing a cell for less than zero as the criteria?
 
H

Howard Brazee

Almost sounds like the sheet has not be recalculated. Also have you
considered testing a cell for less than zero as the criteria?
Click to expand...

Another problem I had was that the spreadsheet kept telling me that it
pointed to some external spreadsheet. I could not find where this
was (it couldn't find the external spreadsheet), but it appeared to be
confusing the name of a page with an external spreadsheet. Breaking
the links fixed everything.
 
B

Bob I

Ah! This is related to the other posting you made then. Yes errors like
that will prevent calculations from completing in spreadsheets, leading
to "odd" behaivior. Thanks for posting back.
 
Top