Check Medication Dosage Compliance
I need to check if the 'Administered Dosage' matches the 'Prescribed Dosage' and return 'Match' or 'Error'. This helps ensure patient safety and medication adherence.
=IF(C2=B2,"Match","Error") How it works: The IF function evaluates a logical test. Here, `C2=B2` checks if the value in the 'Administered Dosage' cell (C2) is exactly equal to the 'Prescribed Dosage' cell (B2). If this condition is TRUE (dosages match), the formula returns 'Match'. If the condition is FALSE (dosages do not match), it returns 'Error', immediately flagging a potential discrepancy for review.
Data Setup
| Patient ID | Prescribed Dosage (mg) | Administered Dosage (mg) |
|---|---|---|
| P001 | 100 | 100 |
| P002 | 50 | 45 |
| P003 | 75 | 75 |
| P004 | 200 | 210 |
| P005 | 150 | 150 |
Step-by-Step Guide
Open your patient medication log in Excel.
Identify the column containing 'Prescribed Dosage' (e.g., Column B) and 'Administered Dosage' (e.g., Column C).
In a new column (e.g., Column D), label the header 'Compliance Check'.
Select the first cell in the 'Compliance Check' column (e.g., D2) where you want the result to appear.
Enter the formula: `=IF(C2=B2,"Match","Error")`
Press Enter. The cell D2 will display 'Match' if the dosages are identical, or 'Error' if they differ.
Drag the fill handle (the small square at the bottom-right corner of cell D2) down to apply the formula to the rest of your patient records.