關於下列 MS- EXCEL，成績介於 100~80 評語為”優”，79~60 評語為”及格”，小於 60 評語為”加油”，則 D2 儲存 格應填入公式？
A=IF(C2>=60,"及格",IF(C2>=80,"優","加油"))
B=IF(C2>=80 && C2<=100,"優",IF(C2>=60,"及格","加油"))
C=IF(C2>=80 and C2<=100,"優",IF(C2>=60,"及格","加油"))
D=IF(AND(C2>=80, C2<=100),"優",IF(C2>=60,"及格","加油"))正確答案
答案與詳解
