I need help consolidating two IF formulas into one formula.
Here are the two formulas.
F1
F2
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.
Any suggestions would be appreciated.
Here are the two formulas.
F1
Code:
=IF(TablesData!G3=FALSE," ",IF(G$20=1,Analysis!F4,IF(G$20=5,Analysis!J4,IF(G$20=10,Analysis!N4))))
Code:
=IF(TablesData!O7=TRUE," ",Analysis!Q4)
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.
Code:
=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)))))