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.