Ask a New Question

I have to average students test scores but if they have taken all five tests, I need to drop the lowest score before averaging

3 answers

What is your question?

I need an excel formula that averages students test scores, dropping the lowest score if all 5 tests are taken

I don't know that there is a program within Excel that does that. You can write one yourself, however.

Ask a New Question or answer this question.

Similar Questions

To find the average of a set of test scores we divide the sum of the test scores by the number of test scores. On her first four
1. 1 answer
Need help asap.You are given a list of students' names and their test scores. Design an algorithm that does the following: a.
1. 0 answers
Kelly's scores on the first three tests in her physics class are 79, 84, and 68. Determine all scores on the fourth test that
1. 1 answer
Wanda wants to have a test average of 90 her four science tests. On the first three tests, she got scores of 84, 96, and 85.
1. 3 answers

more similar questions