>
#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,
?
Tumsime Godfrey
more than 4 weeks ago
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
more than 4 weeks ago
=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
