=LOOKUP(C11, $C$4:C$8, D$4:D$8) Then drag down the formula for other students. How It Works: LOOKUP checks the percentage in C11 Finds the largest value less than or equal to the percentage in the cutoff list C4:C8 Returns the corresponding grade from D4:D8 Enroll today for success! +91 9999468661 info@wifilearning.com www.wifilearning.com
