IF ( AND formula required

[vas6566]

I need suitable formula for column F

	A	B	D	E	F
1	V1	V2	V4	code	deduct
2	21000	100	21100		158.25
3	21500		21500	yes

IF A2 is less than 21000.1,D2*0.75% IF A2 is greater than 21000.1 at the same time if E2 contains the text "yes", now alwo it should return D2*0.75% please share a suitable formula

 

[kevin9999]

Possibly...

Book1
	A	B		D	E	F
1	V1	V2		V4	code	deduct
2	21000	100		21100		158.25
3	21500			21500	yes	161.25
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=IF(OR(A2<21000.1,AND(A2>=21000.1,E2="yes")),D2*0.75%,"no matches")

 

[vas6566]

Possibly...

Book1
	A	B		D	E	F
1	V1	V2		V4	code	deduct
2	21000	100		21100		158.25
3	21500			21500	yes	161.25
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=IF(OR(A2<21000.1,AND(A2>=21000.1,E2="yes")),D2*0.75%,"no matches")

dear kevin 9999, thank you very much for your edcellent response with suitable formula. Thankk you so much

 

[kevin9999]

You're welcome, and thanks for the feedback