用複合 OR 條件決定是否 Needs Review。
來源規則:若 Pass Status=Fail,或 Order Amount >= 20000,或 Priority=Critical,則 Needs Review;否則 OK。
| Student | Status | Order Amount | Priority | Decision |
|---|---|---|---|---|
| Amy | Pass | 18500 | High | OK |
| Brian | Pass | 8200 | Medium | OK |
| Cathy | Pass | 5500 | Low | OK |
| David | Pass | 12000 | High | OK |
| Eva | Fail | 7300 | Medium | Needs Review |
| Frank | Fail | 26000 | Critical | Needs Review |
| Grace | Fail | 6400 | Low | Needs Review |
| Henry | Pass | 9800 | Medium | OK |
| Ivy | Pass | 33000 | Critical | Needs Review |
| Jack | Pass | 11200 | High | OK |
VBA 條件應以 OR 串接三個判斷:Fail、金額 >=20000、Critical。
Needs Review:Eva、Frank、Grace、Ivy,共 4 人;其餘 6 人為 OK。
Ivy 雖為 Pass,但因金額 33,000 且 Priority=Critical,仍需覆核;OR 代表任一風險條件成立就足以觸發。
請把 Review Decision 規則轉成 VBA If + OR,並列出每個 Needs Review 個案的觸發原因。
**問題:**Ivy Priority 改為 High,但 Order Amount 仍 33,000,結果?