Multiple Discount Scenarios

[GLOWE]

Hi, my daughter is opening a business and wants to offer package discounts. Example:

Buy 2 small services or a small and large get 15% Discount
Buy 2 large services get 30% discount

Eg: Small Service - Head Massage, Shoulder Massage

Large Service.- Back Massage, Full Body Massage

How could I do an if formula to calculate this or is there a better way.
Thanks in advance

 

[etaf]

how will the data be laid out in excel
maybe using a countif/s() maybe with a lookup

so if they buy more than 1 and its NOT 2 or more large then 15% discount

 

[GLOWE]

how will the data be laid out in excel
maybe using a countif/s() maybe with a lookup

so if they buy more than 1 and its NOT 2 or more large then

 

[GLOWE]

Hi, actually I think I am a bit premature, we haven't figured out what cells to calculate from. I will be back when I figure that out

 

[etaf]

just an idea , if all on 1 sheet using a VLOOKUP to change the service type into a L or S , this can then be expanded for all services and on a different sheet
Then a List of customers and items and the discount to apply to each service
could add a date , so they have to be purchased on same day

But does need how your layout will be
but just an idea to get you started

Book1
	A	B	C	D	E	F	G
1	Customer	Service	TYPE	Discount
2	FRED	Head Message	S	30%		LOOKUP Service - Can be on different sheet
3	FRED	Back Message	L	30%
4	FRED	Full Body Message	L	30%		Service	Type
5	FRED	Shoulder message	S	30%		Head Message	S
6	John	Back Message	L	0%		Shoulder message	S
7	Tom	Head Message	S	15%		Back Message	L
8	Tom	Shoulder message	S	15%		Full Body Message	L
9	Henry	Head Message	S	15%
10	Henry	Back Message	L	15%
Sheet3

Cell Formulas
Range	Formula
C2:C10	C2	=VLOOKUP(B2,$F$5:$G$8,2,FALSE)
D2:D10	D2	=IF(A2="","",IF(COUNTIFS(A:A,A2,C:C,"L")>1, 30%, IF(COUNTIFS(A:A,A2)>1,15%,0)))