04 Short Formula's ( Fast and Quick work) by Aamir Ali

"Grade Formula ( 2 Formats)"

he most common grade formula in Excel is the Nested IF function, which assigns letter grades based on score thresholds (e.g., A, B, C, D, F). A standard formula for cell B2.

 for approximate matching against a grade table.

This video demonstrates how to use the IF function to create a grade formula in Excel:

1. Nested IF Formula (Best for quick, few conditions) 

This method checks multiple conditions in order. If the score is 90 or higher, it returns "A", otherwise it checks if it's 80 or higher for "B", etc. 

Formula: =IF(B2=90, "A", IF(B2=80, "B", IF(B2=70, "C", IF(B2=60, "D", "F"))))

2. VLOOKUP Formula (Best for large grading scales) 

Create a vertical table with the minimum score for each grade, sorted in ascending order (e.g., 0=F, 60=D, 70=C, 80=B, 90=A). 

Formula: =VLOOKUP(B2, $E$2:$F$6, 2, TRUE)

If you have scores in column B, this formula assigns letter grades based on typical ranges: 

80+ = A+

70-79 = A

60-69 = A-

50-59 = B

40-49 = C

Below 40 = F

Formula: =IF(B2=80, "A+", IF(B2=70, "A", IF(B2=60, "A-", IF(B2=50, "B", IF(B2=40, "C", "F"))))) 

Видео 04 Short Formula's ( Fast and Quick work) by Aamir Ali канала Design Plus Academy