| 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. |
|
#2
|
|||
|
|||
|
how can I fix a #value! error?
if xyz!j3=3
then 013*i6 else 1 But then you have another completely separate If statement there. Did you want =IF(INDIRECT("'xyz'!j3")=3,O13*I6,1) + IF(INDIRECT("'xyz'!j3")=8,O14*I6,1) reloanpro wrote: 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. -- Dave Peterson |
|
#3
|
|||
|
|||
|
how can I fix a #value! error?
Well, you wouldn't want a plus there. But maybe:
=IF(INDIRECT("'xyz'!j3")=3,O13*I6,IF(INDIRECT("'xy z'!j3")=8,O14*I6,1)) Dave Peterson wrote: if xyz!j3=3 then 013*i6 else 1 But then you have another completely separate If statement there. Did you want =IF(INDIRECT("'xyz'!j3")=3,O13*I6,1) + IF(INDIRECT("'xyz'!j3")=8,O14*I6,1) reloanpro wrote: 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. -- Dave Peterson -- Dave Peterson |
|
#4
|
|||
|
|||
|
how can I fix a #value! error?
That's great, Dave. Worked like a charm!
Thanks! Norberto "Dave Peterson" wrote: Well, you wouldn't want a plus there. But maybe: =IF(INDIRECT("'xyz'!j3")=3,O13*I6,IF(INDIRECT("'xy z'!j3")=8,O14*I6,1)) Dave Peterson wrote: if xyz!j3=3 then 013*i6 else 1 But then you have another completely separate If statement there. Did you want =IF(INDIRECT("'xyz'!j3")=3,O13*I6,1) + IF(INDIRECT("'xyz'!j3")=8,O14*I6,1) reloanpro wrote: 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. -- Dave Peterson -- Dave Peterson |
| Reply |
| 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) | |||
Linear Mode
