On the Directors worksheet, in cell D2, enter an IFS function that will determine the status of each director, based on the following conditions. A director is considered Elite if they have directed at least 15 movies with an average score that is greater than 6.5 or has an average score of greater than 6.8 regardless of the number of movies. A director is considered Premiere if they have directed at least 5 movies with an average rating of at least 6. All other directors should have a status of Standard Copy the formula down through cell D28.

\begin{tabular}{|c|c|c|c|l|} \hline 1 & Director & NumOfMovies & AvgScore & Status \\ \hline 2 & Chris Miller & 2 & 6.4 & \\ \hline 3 & Jay Russell & 4 & 6.68 & \\ \hline 4 & Mark Waters & 10 & 6.14 & \\ \hline 5 & Kasi Lemmons & 3 & 6.9 & \\ \hline 6 & Joe Nussbaum & 3 & 5.67 & \\ \hline 7 & John Harrison & 1 & 6.2 & \\ \hline 8 & Michael Lehmann & 8 & 5.88 & \\ \hline 9 & Jaume Balaguer & 2 & 6 & \\ \hline 10 & Robert Klane & 1 & 4.6 & \\ \hline 11 & Kunihiko Yuyama & 2 & 5.85 & \\ \hline 12 & Charles Grosvenor & 1 & 6.5 & \\ \hline 13 & Oliver Stone & 17 & 6.93 & \\ \hline 14 & John McTiernan & 11 & 6.54 & \\ \hline 15 & Steve Martino & 2 & 6.85 & \\ \hline 16 & Shekhar Kapur & 3 & 6.97 & \\ \hline 17 & Adam McKay & 6 & 6.92 & \\ \hline 18 & Dennis Dugan & 14 & 5.79 & \\ \hline 19 & Julien Temple & 2 & 5.4 & \\ \hline 20 & Nanette Burstein & 1 & 6.3 & \\ \hline 21 & William Malone & 2 & 4.45 & \\ \hline 22 & Fred Olen Ray & 2 & 4.65 & \\ \hline 23 & Joachim Rnning & 1 & 7.2 & \\ \hline 24 & Jake Kasdan & 5 & 6.14 & \\ \hline 25 & Kevin Smith & 11 & 6.73 & \\ \hline 26 & Stephen Sommers & 7 & 6.19 & \\ \hline 27 & Steve Antin & 1 & 6.4 & \\ \hline 28 & Tim Burton & 17 & 7.07 & \\ \hline \end{tabular}