Tumsime Godfrey
Apr 12
Use the IF command to develop a formula to generate students GRADE given the following grade ranges:A=86-100,B=66-85,C=51-65,D=41-50,E=21-40,F=00-20, ?
1 view
1 view
1 answer
Sort By
ChatGPT
Apr 12
=IF(A1>=86,"A",IF(A1>=66,"B",IF(A1>=51,"C",IF(A1>=41,"D",IF(A1>=21,"E","F")))))
This formula will generate the student's grade based on the score in cell A1.
This formula will generate the student's grade based on the score in cell A1.
0
