How do I write an Excel formula or formula in cell Events!G3, which can be copied down the column and across the row to column J, to determine the Performance Round the gymnast will perform in for the corresponding event. If they are not performing in the event put a "-" in the cell. Also confused on doing an Excel formula and/or function in cell Events!T3, which can be copied down the column, to determine if the gymnast's all-around score is greater than their team's average score(TRUE or FALSE).

A B C D E F G H I J K 1 M N O P a R R S T Individual All Around Score Score More than Team's Avg 1 Entry Team Performance Round bars floor beam vault 2 3 4 4 5 37.70 37.70 1001 1002 1003 1004 MSU OSU MSU IU 6 7 MSU - OSU 8 9 10 1005 1006 1007 1008 Performed in Event beam bars floor vault TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE | TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE Average Score Medals beam bars floor vault beam bars floor vault 9.33 9.42 9.65 9.30 Silver 9.67 8.90 9.63 9.50 Gold - Bronze Bronze 9.48 8.959.54 | 9.40 Silver - 8.98 9.489.55 9.30 - Gold 8.75 9.469.48 | 9.22 - Bronze 0.00 9.25 9.70 9.33 Gold 0.00 8.90 8.92 9.13 9.45 8.55 9.05 9.45 9.30 9.459.38 | 9.25 8.58 8.90 8.80 9.54 Silver 9.28 8.00 9.25 9.66 - Gold 8.90 8.60 8.50 9.45 9.46 9.05 0.00 8.98 Bronze - 9.30 9.479.13 9.32 - Silver - 0.00 9.048.98 | 9.48 37.37 37.30 36.91 28.28 26.95 36.50 37.38 IU IU - - IU OSU - 35.82 - - 11 1009 12 1010 13 1011 14 1012 15 1013 16 1014 17 1015 18 OSU MSU IU OSU MSU 36.19 35.45 27.49 37.22 27.50 FALSE TRUE TRUE TRUE 19 20 21 22 22 GymnastTeam Summary Levels Events + A B C D E F. G H I Practice Hours Team Level MSU Class Rank Junior Freshman 9 16 OSU MSU 5 9 2S 16 JU 2 5 2 Overall Number Number Average of Events of Medals Score 4 1 9.43 4 3 9.42 4 1 9.34 4 1 9.33 4 1 9.23 3 1 7.07 3 0 6.74 4 0 9.13 4 0 9.34 4 1 8.95 4 1 9.05 MSU OSU 2 IU 00 8 12 BABBEH O O OU WNP Entry 1 Number Gymnast 1001 Zoey Mullins 1002 Edith Bloom 1003 Shirley Blake 1004 Ruby Getty 1005 Rachel Werth 1006 Piper Parker 1007 Peyton Runyon 1008 Olivia Jakobs 10 1009 Margo Jay 11 1010 Rose Ballard 12 1011 Hannah Widger 13 1012 Evie Juliet 14 1013 Erin Zimmerman 15 1014 Elizabeth James 16 1015 Audrey Hageman 17 Gymnast Team Summary Levels 5 Senior Sophomore Freshman Freshman Senior Sophomore Sophomore Senior Sophomore Junior Freshman Junior Freshman IU IU 2 OSU 10 20 2 na 100 000 N 8 12 4 0 OSU MSU IU OSU 8.86 6 2 3 1 12 4 1 6.87 9.30 6.87 MSU 6 3 0 Events + A B C D E F G G 9 10 4 5 4 4 1 Practice Requirements by Level 2 Level # 5 6 7 8 3 Time (Hrs/Day) 2 2 3 4 4 Days/Week 1 1 2 3 5 6 Round of Performances 7 vault beam floor bars 8 Levels 5-6 Round 1 Round 2 Round 3 Round 4 9 Levels 7-8 Round 2 Round 3 Round 4 Round 1 10 Levels 9-10 Round 3 Round 4 Round 1 Round 2 11 Gymnast Team Summary Levels Events A B C D E F G H I J K 1 M N O P a R R S T Individual All Around Score Score More than Team's Avg 1 Entry Team Performance Round bars floor beam vault 2 3 4 4 5 37.70 37.70 1001 1002 1003 1004 MSU OSU MSU IU 6 7 MSU - OSU 8 9 10 1005 1006 1007 1008 Performed in Event beam bars floor vault TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE | TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE TRUE TRUE TRUE TRUE Average Score Medals beam bars floor vault beam bars floor vault 9.33 9.42 9.65 9.30 Silver 9.67 8.90 9.63 9.50 Gold - Bronze Bronze 9.48 8.959.54 | 9.40 Silver - 8.98 9.489.55 9.30 - Gold 8.75 9.469.48 | 9.22 - Bronze 0.00 9.25 9.70 9.33 Gold 0.00 8.90 8.92 9.13 9.45 8.55 9.05 9.45 9.30 9.459.38 | 9.25 8.58 8.90 8.80 9.54 Silver 9.28 8.00 9.25 9.66 - Gold 8.90 8.60 8.50 9.45 9.46 9.05 0.00 8.98 Bronze - 9.30 9.479.13 9.32 - Silver - 0.00 9.048.98 | 9.48 37.37 37.30 36.91 28.28 26.95 36.50 37.38 IU IU - - IU OSU - 35.82 - - 11 1009 12 1010 13 1011 14 1012 15 1013 16 1014 17 1015 18 OSU MSU IU OSU MSU 36.19 35.45 27.49 37.22 27.50 FALSE TRUE TRUE TRUE 19 20 21 22 22 GymnastTeam Summary Levels Events + A B C D E F. G H I Practice Hours Team Level MSU Class Rank Junior Freshman 9 16 OSU MSU 5 9 2S 16 JU 2 5 2 Overall Number Number Average of Events of Medals Score 4 1 9.43 4 3 9.42 4 1 9.34 4 1 9.33 4 1 9.23 3 1 7.07 3 0 6.74 4 0 9.13 4 0 9.34 4 1 8.95 4 1 9.05 MSU OSU 2 IU 00 8 12 BABBEH O O OU WNP Entry 1 Number Gymnast 1001 Zoey Mullins 1002 Edith Bloom 1003 Shirley Blake 1004 Ruby Getty 1005 Rachel Werth 1006 Piper Parker 1007 Peyton Runyon 1008 Olivia Jakobs 10 1009 Margo Jay 11 1010 Rose Ballard 12 1011 Hannah Widger 13 1012 Evie Juliet 14 1013 Erin Zimmerman 15 1014 Elizabeth James 16 1015 Audrey Hageman 17 Gymnast Team Summary Levels 5 Senior Sophomore Freshman Freshman Senior Sophomore Sophomore Senior Sophomore Junior Freshman Junior Freshman IU IU 2 OSU 10 20 2 na 100 000 N 8 12 4 0 OSU MSU IU OSU 8.86 6 2 3 1 12 4 1 6.87 9.30 6.87 MSU 6 3 0 Events + A B C D E F G G 9 10 4 5 4 4 1 Practice Requirements by Level 2 Level # 5 6 7 8 3 Time (Hrs/Day) 2 2 3 4 4 Days/Week 1 1 2 3 5 6 Round of Performances 7 vault beam floor bars 8 Levels 5-6 Round 1 Round 2 Round 3 Round 4 9 Levels 7-8 Round 2 Round 3 Round 4 Round 1 10 Levels 9-10 Round 3 Round 4 Round 1 Round 2 11 Gymnast Team Summary Levels Events