I am trying to create a formula so if cell A43 equals 9 and cell X19 has data it runs the IF statement, other wise leave the cell blank. But if cell A43 equals 10 and both of cells X19 and X31 have data it runs the if statement, other wise leave the cell blank. This is the string I created but it always leaves the cell blank. Any help is appreciated:
=IF(AND(OR(Scores!A43=9),(ISBLANK(Scores!X19))),"",IF(BY44=Scores!A31,0,BV44)),IF(AND(OR(Scores!A43=10),ISBLANK(ScoresX31),(ISBLANK(Scores!X19))),"",IF(BY44=Scores!A31,0,BV44))
Bookmarks