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) |