how can I fix a #value! error?

[reloanpro]

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]

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)

 

[Dave Peterson]

Well, you wouldn't want a plus there. But maybe:

=IF(INDIRECT("'xyz'!j3")=3,O13*I6,IF(INDIRECT("'xyz'!j3")=8,O14*I6,1))

 

[reloanpro]

That's great, Dave. Worked like a charm!

Thanks!

Norberto

Well, you wouldn't want a plus there. But maybe:

=IF(INDIRECT("'xyz'!j3")=3,O13*I6,IF(INDIRECT("'xyz'!j3")=8,O14*I6,1))