I do believe I just made the most epic nested IF statement I've ever done in Excel =IF(((B21*0.1)+(B36*0.25)+(B55*0.3)+(B49*0.1)+(B59*0.25))>0.9,"A",IF(AND(((B21*0.1)+(B36*0.25)+(B55*0.3)+(B49*0.1)+(B59*0.25))<0.9,((B21*0.1)+(B36*0.25)+(B55*0.3)+(B49*0.1)+(B59*0.25))>0.79499),"B",IF(AND(((B21*0.1)+(B36*0.25)+(B55*0.3)+(B49*0.1)+(B59*0.25))<0.8,((B21*0.1)+(B36*0.25)+(B55*0.3)+(B49*0.1)+(B59*0.25))>0.69499),"C",IF(AND(((B21*0.1)+(B36*0.25)+(B55*0.3)+(B49*0.1)+(B59*0.25))<0.7,((B21*0.1)+(B36*0.25)+(B55*0.3)+(B49*0.1)+(B59*0.25))>0.59499),"D","F")))) yes, this is the shit I come up when I'm bored (Excel Gradebook in this case)