用 If 同時檢查 Score 與 Attendance。
來源規則:Score >= 60 且 Attendance >= 80% 才為 Pass,否則 Fail。
| Student | Score | Attendance | Status |
|---|---|---|---|
| Amy | 95 | 96% | Pass |
| Brian | 87 | 92% | Pass |
| Cathy | 74 | 88% | Pass |
| David | 61 | 82% | Pass |
| Eva | 58 | 91% | Fail |
| Frank | 45 | 74% | Fail |
| Grace | 82 | 79% | Fail |
| Henry | 69 | 86% | Pass |
| Ivy | 91 | 98% | Pass |
| Jack | 76 | 83% | Pass |
VBA 邏輯:If Score >= 60 And Attendance >= 0.8 Then Pass Else Fail。
Pass 7 人;Fail 3 人:Eva、Frank、Grace。
Grace 分數 82 但 Attendance 79%,仍為 Fail;Eva Attendance 91% 但 Score 58,也為 Fail。這正是 AND 條件的核心。
請依來源門檻建立 Pass Status VBA,並逐筆檢查未通過者是哪個條件失敗。
**問題:**Grace Attendance 79%→80%,結果?