Tumsime Godfrey
Apr 7
Use the "IF"command to develop formula to generate students GRADE given the following grade range A=81-100,B=61-80,C=41-60,D=21-40, ?
1 view
1 view
1 answer
Sort By
ChatGPT
Apr 7
IF(A2>=81,"A",IF(A2>=61,"B",IF(A2>=41,"C",IF(A2>=21,"D","F"))))
This formula will generate the student's grade based on the score in cell A2. If the score is 81 or higher, it will return "A", if the score is between 61 and 80, it will return "B", if the score is between 41 and 60, it will return "C", if the score is between 21 and 40, it will return "D", and if the score is below 21, it will return "F".
This formula will generate the student's grade based on the score in cell A2. If the score is 81 or higher, it will return "A", if the score is between 61 and 80, it will return "B", if the score is between 41 and 60, it will return "C", if the score is between 21 and 40, it will return "D", and if the score is below 21, it will return "F".
0
