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