This may be an easy question. I looked around using Search but didn't see this. Is there a way in Excel 2003, formula or otherwise, to have a formula evaluate the result of another formula?
Specifically, I have one column (we'll say Column B) of cells with a formula referencing another column (Column A). This is a simplification of it: IF(A1>0, do stuff, ""), so if the cell in Column A is blank, it won't display anything. The problem is that column A has a formula referencing another spreadsheet using the same IF function, so while it may look blank (and is, as far as this is concerned), it's never actually blank as far as Excel cares (the formula is always there, so it's technically not blank).
Is there a way to do something like: IF(RESULT(A1)>0, do stuff, "")? I tried Value(), but that does nothing. As it is now, the column is showing #VALUE!, where if I delete the formula in Column A, it's blank as I want it. Is what I'm looking for possible?