Ravi Sir's Cards › Excel
Salon Management System in Excel (card 1 of 2)
Revision card 1 for Salon Management System in Excel: Amount only when Done: =IF(M5="Done",ROUND(H5*(1-J5),0),0) gives ₹200; Visit days: =SUMIFS(Appointments!$N$5:$N$300,Appointments!$D$5:$D$300,A5) gives 2; Spend: =SUMIFS(Appointments!$K$5:$K$300,Appointments!$D$5:$D$300,A5) gives ₹350.
Read card text
What this card says
1 for Salon Management System in Excel: Amount only when Done: =IF(M5="Done",ROUND(H5*(1-J5),0),0) gives ₹200
Visit days: =SUMIFS(Appointments!$N$5:$N$300,Appointments!$D$5:$D$300,A5) gives 2
Spend: =SUMIFS(Appointments!$K$5:$K$300,Appointments!$D$5:$D$300,A5) gives ₹350.
Learn this in the lesson: Salon Management System in Excel: Appointments, Client History, Repeat Clients, Stylist Sales and Commission