> #programming , #excel-formula , #computer-science > 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, ?
T
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
C
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.
0

Similar Questions

×
Anonymous





© 2024 - Quanswer