Ravi Sir's Cards › Excel
Laundry Management System in Excel (card 1 of 2)
Revision card 1 for Laundry Management System in Excel: Item and service key: =A5&"|"&B5 gives Shirt|Wash and iron; Line amount: =D5*E5 gives ₹80; Line key for the receipt: =A5&"-"&COUNTIF($A$5:A5,A5) gives L-001-1. Includes an example data table.
Read card text
What this card says
1 for Laundry Management System in Excel: Item and service key: =A5&"|"&B5 gives Shirt|Wash and iron
Line amount: =D5*E5 gives ₹80
Line key for the receipt: =A5&"-"&COUNTIF($A$5:A5,A5) gives L-001-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