Ravi Sir's Cards › Excel
Laundry Management System in Excel (card 2 of 2)
Revision card 2 for Laundry Management System in Excel: Due date: =B5+IF(D5="Yes",Setup!$B$6,Setup!$B$5) gives 04-10-2026; Share of express orders: =COUNTIF(Orders!$D$5:$D$2000,"Yes")/COUNTA(Orders!$A$5:$A$2000) gives 17.1%. Includes an example data table.
Read card text
What this card says
2 for Laundry Management System in Excel: Due date: =B5+IF(D5="Yes",Setup!$B$6,Setup!$B$5) gives 04-10-2026
Share of express orders: =COUNTIF(Orders!$D$5:$D$2000,"Yes")/COUNTA(Orders!$A$5:$A$2000) gives 17.1%. Includes an
Example
data table
Learn this in the lesson: Laundry Management System in Excel: Price List, Order Lines, Express Surcharge, Due Dates, Receipts and Dashboard