My formula:

=IF((OR(IF((VLOOKUP(LARGE(C5:C10,1),C5:C10,1,FALSE))<>$C7,0,1)>0,IF((VLOOKUP(LARGE(C5:C10,2),C5:C10,1,FALSE))<>$C7,0,1)>0)),1,IF(($E7+$G7)=0,IF((HLOOKUP(LARGE($B7:$D7,1),$B7:$D7,1,FALSE))<>$C7,0,1),0))

When I ran the "Evaluate Formula" function, the formula was shortened down to "IF(FALSE,#N/A,1)". I did this because the formula wasn't doing what I thought it would do. Why am I getting the "#N/A"?

Thanks, in advance!

-Scientia