Forum Discussion
Nested formula
Hello! My name is Oromokoma Charles. I am trying to use the nested =if(and() to write an expression that grades students according to a number of cells for instance students' scores are entered in ce...
Shouldn't Student R get a C (grade 3) since E3=9?
In G1 as an array formula confirmed with Ctrl+Shift+Enter:
=IF(AND(F1<=12,B1:E1<9),"A",IF(AND(F1<=24,B1:E1<9),"B",IF(AND(F1<=28,B1:E1<9),"C",IF(F1<=32,"D","-"))))
Fill down.