=IF(ISERROR( INDIRECT (" QueryData!R52")), "", INDIRECT("QueryData!R52"))
2007-07-16 18:44:11 · 4 answers · asked by THE 2 in Computers & Internet ➔ Programming & Design
INDIRECT returns a vaule referenced by a text string. For example: INDIRECT("A1") will return you the value in cell A1.
ISERROR(X) will return true if X is not valid. For example, you have 2 in cell B1 and 0 in cell B2. You say ISERROR(B1/B2) will give you TRUE because the answer is not valid since you can't divide a number by zero.
IF is a conditioning statment. IF(Condition,Yes,No). So, if your condition is TRUE, then it will do whatever in the YES place, or else it will do whatever in the No place.
So, if we combine all, QueryData!R52 is some place from other excel sheet named "QueryData" and cell R52. You retrive the value from the place, and check if it is an error. If it is an error, then don't put anything "" (empty string). If it is not an error, then assign the value you received to the cell where you get the formula from.
You can find the QueryData in the same excel file, just navigate through the tab at the bottom in Excel.
Hope you get it.
2007-07-16 19:00:04 · answer #1 · answered by Lain Lain 3 · 1⤊ 0⤋
Print what's in R52 in the QueryData sheet, but leave the cell blank if there is an error.
2007-07-17 01:53:13 · answer #2 · answered by Michael M 6 · 1⤊ 0⤋
Someone has written some function to check some value from the database.
2007-07-17 01:48:18 · answer #3 · answered by candy 3 · 0⤊ 2⤋
It's a formula. Hence the = sign.
It's a very complex formula and may have an error in it.
2007-07-17 01:49:18 · answer #4 · answered by Bill 2 · 0⤊ 2⤋