2. Then, input the data information such as students' grades into the worksheet, and the last column is the scholarship.
3. Then select the F2 cell and enter the formula "=IF(COUNTIF(C2:E2,"> = 85 ") = 3,200, IF(COUNTIF(C2:E2," & gt=75")=3, 100,50)) ".
4. Click ctrl+shift+enter to get the scholarship for the students in the second row.
5. Then drag the lower right corner of F2 cell and fill the F column down.
6. After completing the form, you can judge the scholarship amount of all students and output it in column F of the form.