Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula not evaluating immediately
I have the following formula in my procedu
=IF(ISNUMBER(SEARCH(Z$1,FORMULATEXT(INDIRECT("'["&$G3&"]Summary (A)'!$I$11",TRUE)),1)),"YES","NO") G3 is a workbook name like Workbook.xls. When the procedure executes, the result is displayed as "NO" in the sheet. If I then go back and press ENTER on the field, it changes to YES. The procedure has a CALCULATE statement in it just in case I've got manual calculation set on my system. I actually have it set to automatic right now. I have a similar formula in other cells that works without a problem. I'm not sure what the problem is. Can someone assist? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Evaluating a DDE formula created by strings | Excel Worksheet Functions | |||
Evaluating formula in VBA | New Users to Excel | |||
Evaluating more than 30 conditions using a formula | Excel Worksheet Functions | |||
evaluating text as if it were a formula | Excel Discussion (Misc queries) | |||
If formula evaluating 2 cells contents | Excel Worksheet Functions |