把 Attendance %、Customer Rating、Training Completed 三個條件整合成 Alert,判斷是否需要複核。
能使用 OR 邏輯處理多條件警示,並理解「任一條件成立」與「全部條件成立」的差異。
來源規則要求:Attendance < 90%、Customer Rating < 4、Training Completed = No,只要任一條件成立,Alert 顯示 Needs Review。
| Name | Attendance % | Customer Rating | Training Completed |
|---|---|---|---|
| Kuldeep | 89% | 3.8 | No |
| Julie | 86% | 3.6 | No |
| Neena | 90% | 3.9 | Yes |
| Andre | 84% | 3.4 | No |
| Shilpa | 88% | 3.7 | No |
| Aalok | 87% | 3.5 | No |
| Raja | 96% | 4.6 | Yes |
可用 =IF(OR(H4<90%,I4<4,J4="No"),"Needs Review","OK")。若要把整列醒目提示,來源手動解法示範使用 =$P4="Needs Review" 作為條件格式公式。
| Name | Alert | 主要觸發原因 |
|---|---|---|
| Kuldeep | Needs Review | Attendance、Rating、Training |
| Julie | Needs Review | Attendance、Rating、Training |
| Neena | Needs Review | Rating < 4 |
| Andre | Needs Review | Attendance、Rating、Training |
| Shilpa | Needs Review | Attendance、Rating、Training |
| Aalok | Needs Review | Attendance、Rating、Training |
| Raja | OK | 無 |
Neena 的 Attendance 正好 90%、Training = Yes,但 Rating 3.9 仍足以觸發警示,顯示這是 OR 邏輯,不是三條件都要失敗。
請依 Attendance < 90%、Customer Rating < 4、Training Completed = No 的 OR 條件產生 Alert,並列出每位 Needs Review 的觸發原因。
**問題:**若 Neena 的 Customer Rating 從 3.9 提高到 4.0,Alert 會如何變?
**精簡解答:**Attendance = 90% 不低於 90%、Rating = 4.0 不低於 4、Training = Yes,因此三個條件皆不觸發,Alert 由 Needs Review 變成 OK。