Excel Forum
Similar Content
Logical Operators in Excel VBA Macros
Tutorial: Logical operators in VBA allow you to make decisions when certain conditions are met. They...
Multiple Conditional Formatting Rules for a Cell in Excel
Tutorial: Apply multiple Conditional Formatting rules to a cell or range in Excel. This allows you ...
Apply Conditional Formatting to Multiple Cells with a Single Formula
Tutorial: How to use a single formula to apply conditional formatting to multiple cells at once in E...

Excel Magic Trick 768: Gradebook Average w Criteria and Conditionally Format Less Than 4 Tests Taken

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to create array formulas for Gradebook Average with Criteria and Conditionally Format less than 4 Tests Taken. See the Functions AVERAGE, IF, SUMPRODUCT.

Got a Question? Ask it Here in the Forum.