Ravi Sir's Cards › Excel
Salon Management System in Excel (card 2 of 2)
Revision card 2 for Salon Management System in Excel: Repeat client?: =IF(B5>=2,"Yes","No") gives Yes; Stylist sales: =SUMIFS(Appointments!$K$5:$K$300,Appointments!$G$5:$G$300,A5) gives ₹4,880; Commission: =ROUND(D5*Setup!$B$4,0) gives ₹976. Includes an example data table.
Read card text
What this card says
2 for Salon Management System in Excel: Repeat client?: =IF(B5>=2,"Yes","No") gives Yes
Stylist sales: =SUMIFS(Appointments!$K$5:$K$300,Appointments!$G$5:$G$300,A5) gives ₹4,880
Commission: =ROUND(D5*Setup!$B$4,0) gives ₹976. Includes an
Example
data table
Learn this in the lesson: Salon Management System in Excel: Appointments, Client History, Repeat Clients, Stylist Sales and Commission