Ravi Sir's Cards › Excel
Medicine Refill Reminder in Excel (card 2 of 2)
Revision card 2 for Medicine Refill Reminder in Excel: Refill now / Soon / OK: =IF(D7<=7,"Refill now",IF(D7<=14,"Soon","OK")) gives Soon; Packs to buy for the next 30 days: =MAX(0,ROUNDUP((30*B7/7-C7)/H7,0)) gives 2; Refill cost: =J7*I7 gives ₹240.
Read card text
What this card says
2 for Medicine Refill Reminder in Excel: Refill now / Soon / OK: =IF(D7<=7,"Refill now",IF(D7<=14,"Soon","OK")) gives Soon
Packs to buy for the next 30 days: =MAX(0,ROUNDUP((30*B7/7-C7)/H7,0)) gives 2
Refill cost: =J7*I7 gives ₹240.
Learn this in the lesson: Medicine Refill Reminder in Excel: Tablets Left, Days of Stock and Refill-by Dates