Need Help Consoldating two IF formulas into 1

[atvsource]

I need help consolidating two IF formulas into one formula.

Here are the two formulas.

F1

=IF(TablesData!G3=FALSE," ",IF(G$20=1,Analysis!F4,IF(G$20=5,Analysis!J4,IF(G$20=10,Analysis!N4))))

F2

=IF(TablesData!O7=TRUE," ",Analysis!Q4)

Here's what the two formulas do.
F1 take the TablesData!G3=FALSE and checks to see if that is FALSE, controlled by a form check box, and if FALSE, will make the entire formula not show any results of the IF statements. The G$20=1,5,10 will check to see if those values = 1,5,10 and return the corresponding cells data.

F2 takes the same approch with TablesData!07=TRUE and check to see if that is TRUE, controlled by a form check box, and if TRUE, will make the entire forumla not show any results IF statements. If it returns a false, the cell returns the data in cell Analysis!Q4.

Now, I would like to combine these two into one so if either or of the form check boxes are check, the forumla either show or doesn't show the results.

Can this be done and how would one setup the formula, as I'm stuck.

Here's the formula I've tried without good results, as I cannot get it to toggle to the very last IF.

=IF(TablesData!G3=FALSE,"",IF(G$20=1,Analysis!F4,IF(G$20=5,Analysis!J4,IF(G$20=10,Analysis!N4,IF(TablesData!O11=TRUE," ",Analysis!Q4)))))

Any suggestions would be appreciated.

 

[atvsource]

Even removing the IF(TablesData!G4=FALSE,"" the remaining formula still does not work, so I don't think it matters if the TablesData!G4 is there or not, as I don't see the wrong in it, as it only hides the value in the cell and nothing else.

If I'm completely wrong, I might need to have it spelled out in detailed english.

 

[atvsource]

I decided to just increase the worksheet to include two additional columns and work out the data in separate IF statements.

=IF(TablesData!G3=FALSE," ",IF(TablesData!O$15=TRUE,Analysis!R4,IF(TablesData!O$15=FALSE,Analysis!S4,"")))

It works, but require more work to keep things updated.