If you're using Excel to track your grades, there may be times when you want to throw out the lowest score in a particular category. For example, let's say you have five tests and you want to find your average grade. However, you know that one of the tests was significantly harder than the others, so you want to exclude that score from your calculation.
There are a few different ways that you can go about doing this. One option is to use the AVERAGE function. This function will take all of the values in a range and calculate the average. However, there is an optional argument that allows you to specify which values should be included in the calculation.
For example, let's say that your five test scores are in cells A1 through A5. You could use the following formula to find the average of those five scores:
However, let's say that you want to exclude the lowest score from the calculation. In that case, you could use this formula:
The "1" in this formula tells Excel to exclude the lowest value from the calculation. You could also use "-1" to tell Excel to exclude the highest value.
Another option is to use the MAX function. This function returns the highest value in a range of cells. So, if you wanted to find the average of your five test scores, excluding the lowest score, you could use this formula: