How to judge grades based on grades
1. Usage scenarios
- 90-100 excellent, 75-89 good, 60-74 pass, 59 points below for failure.
When filling in the score, automatic recognition and so on. Use the IF() function.
IF(A,B,C) function can be understoodIf A is satisfied, B is returned. Otherwise, C is executed/returned..
IF(A,B,IF(C,D,E) is understoodIf A is satisfied, B is returned; If A is not satisfied but C is satisfied, D is returned; If both A and C are not satisfied, E is returned..
If the score is greater than or equal to 90, it is excellent. Otherwise, if the score is greater than or equal to 75 (actually 90> score> = 75), it is good, otherwise, if the score is greater than or equal to 60 (in fact, it is 75> score> = 60), it will pass, and if you are not satisfied, the score will be less than 60, and it will fail.
In this example, one is to show the usage of IF functions, and the other is to say that the functions that are suitable for matching can be nested. Through appropriate nesting, various functions can be realized.
2. Effect demonstration
YIDA in order to better optimize the content and quality of YIDA user manual, it takes you 3-5 minutes to fill in the document feedback questionnaire. The document feedback questionnaire is submitted anonymously, and the questionnaire information is only used for YIDA document experience feedback collection. Thank you for your support for YIDA!
-------------------- Get the latest information YIDA, welcome to follow US--------------------
