Forum Discussion
Re: strugling with a nested formula
Perhaps, this formula returns your desired result:
=IF(AND(Part1!B5>0,Part1!B6>0,Part1!J19>0),
Part1!B5,
"ERROR")
=IF(AND(Part1!B5>0,Part1!B6>0,Part1!J19>0),
Part1!B5,
"ERROR")
1 Reply
As I understood the logic is
if <at least one entered> then if <all entered> then B5 else "ERROR" else <empty string>
which is directly translated into nested IF
