44.利用 Excel 計算成績(如下圖所示),老師想要在「備註」欄中以星號(*)標示期末考及格但是學 期成績不及格者的學生資料,則其公式應該是下列何者?
(A) =IF(E2>=60,IF(F2<60,"*",""))
(B) =IF(F2<60,IF(E2>=60,"*",""))
(C) =IF(OR(E2>=60,F2<60),"*","")
(D) =IF(AND(E2>=60,F2<60),"*","")
答案:登入後查看
統計: A(9), B(0), C(1), D(8), E(0) #2279021
統計: A(9), B(0), C(1), D(8), E(0) #2279021