N
NotExcelingNow
I thought I would post part of the formula that you all have helped me with
just to say thank you.
I got everything running now.
There were 7 formulas like this one plus 2 data tables one of which had 12
"TRUE" formulas
=ROUND(IF(O63=TRUE,AVERAGE(P45:Q46),IF(D61=TRUE,AVERAGE(P44:Q46),IF(E61=TRUE,AVERAGE(P43:Q46),IF(F61=TRUE,AVERAGE(P42:Q46),IF(G61=TRUE,AVERAGE(P41:Q46),IF(H61=TRUE,AVERAGE(P40:Q46),P46)))))),0)
=AND(M63=TRUE,H46=H45,H45=H44,H44=H43,H43=H42,H41=H42,H41=H40)
=IF(O63=TRUE,"The average ",IF(D61=TRUE,"The average ",IF(E61=TRUE,"The
average ",IF(F61=TRUE,"The average ",IF(G61=TRUE,"The average
",IF(H61=TRUE,"The average ","The "))))))
I got everything running just like I wanted, thank you sooo much!
just to say thank you.
I got everything running now.
There were 7 formulas like this one plus 2 data tables one of which had 12
"TRUE" formulas
=ROUND(IF(O63=TRUE,AVERAGE(P45:Q46),IF(D61=TRUE,AVERAGE(P44:Q46),IF(E61=TRUE,AVERAGE(P43:Q46),IF(F61=TRUE,AVERAGE(P42:Q46),IF(G61=TRUE,AVERAGE(P41:Q46),IF(H61=TRUE,AVERAGE(P40:Q46),P46)))))),0)
=AND(M63=TRUE,H46=H45,H45=H44,H44=H43,H43=H42,H41=H42,H41=H40)
=IF(O63=TRUE,"The average ",IF(D61=TRUE,"The average ",IF(E61=TRUE,"The
average ",IF(F61=TRUE,"The average ",IF(G61=TRUE,"The average
",IF(H61=TRUE,"The average ","The "))))))
I got everything running just like I wanted, thank you sooo much!