| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can I fix a #value! error?
I get a #VALUE! with the following formula:
"=IF(INDIRECT("'xyz'!j3")=3,O13*I6,1),IF(INDIRECT( "'xyz'!j3")=8,O14*I6,1),..." The logic seems to work, as values are correct when I evaluate the calculation steps. Any help is appeciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| ERROR | Excel Discussion (Misc queries) | |||
Threaded Mode
