Excel Magic Trick 1175

Decaying Average in Standards-Based Grading in Excel

DESCRIPTION

See
(00:10) How Decaying Average in Standards-Based Grading works
(02:00) Calculating in Excel Method 1: Two formulas that use IF function and Absolute Cell References
(04:02) Explaining logic of how IF function works. See LEN Function to check and see what IF function actually puts into the cell.
(05:30) Calculating in Excel Method 2: One formula that use two IF functions and Absolute Cell References, and the column Header is empty
(07:17) Calculating in Excel Method 3: One formula that use two IF functions, ISTEXT function and Absolute Cell References, and the column Header contains text
(08:05) Calculating in Excel Method 4: One formula that use two IF functions and Absolute Cell References, and the column Header contains a zero with Custom Number Formatting to show the text “Decaying Ave.”




Be the first to comment

Leave a Reply