Ravi Sir's Cards › Excel
Pharmacy Management System in Excel (card 2 of 2)
Revision card 2 for Pharmacy Management System in Excel: Closing stock: =C5-D5 gives 90; Days to expiry: =G5-Setup!$B$3 gives 318; Expired, Near expiry or OK: =IF(H5<0,"Expired",IF(H5<=Setup!$B$5,"Near expiry","OK")) gives OK. Includes an example data table.
Read card text
What this card says
2 for Pharmacy Management System in Excel: Closing stock: =C5-D5 gives 90
Days to expiry: =G5-Setup!$B$3 gives 318
Expired, Near expiry or OK: =IF(H5<0,"Expired",IF(H5<=Setup!$B$5,"Near expiry","OK")) gives OK. Includes an
Example
data table
Learn this in the lesson: Pharmacy Management System in Excel: Items, Sales Bills, Stock, Expiry Alerts and Dashboard