Formula based on certain cells data

[T3as3r22]

Hi there,

I have attached a screenshot for the reference.

=IF(AND($AC$1="exact",AB2<=AR2, AI2>=500, AP2<=100%,AQ2<=30%), AB2*1.2, AB2*0.9)

So if this is true, ($AC$1="exact",AB2<=AR2, AI2>=500, AP2<=100%,AQ2<=30%) than I want a final bid to be 1.2% (increase by 20%) of the current bid (AB column), and this is not true than I want a final bid to be 0.90% (reduce by 10%) of the current bid (AB column). But I am not getting the result.

Can anyone please help me solve this?

TIA.
T3as3r22

 

[Fluff]

What I want is that if conversion rate is <= 100% and ACOS is <= 30% than bid to be 20% higher if not than 10% lower

Do you mean you're not interested in the other criteria in your formula?

 

[awoohaw]

you get same result with just that criteria:

mr excel questions 27.xlsm
	AB	AC						AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV		AX
1	Bid	Match Type						Impressions	Clicks	Click-through Rate	Spend	Sales	Orders	Units	Conversion Rate	Acos	CPC	ROAS	CPA	AoV	Affordable Bids		Final Bids
2	1.20	exact						707	1	0.14%	4.24	49.99	2	2	200.00%	8.48%	4.24	11.79	2.12	25	10		1.08
13	0.04	exact						115	2	1.74%	12.93	12.99	1	1	50.00%	99.54%	6.46	1	12.9	13	1.3		0.036
14	0.04	exact						115	2	1.74%	12.93	12.99	1	1	50.00%	99.54%	6.46	1	12.9	13	1.3		0.036
T3as3r22

Cell Formulas
Range	Formula
AX2	AX2	=IF(AND($AC1="exact",$AB2<=$AR2,$AI2>=500,$AP2<=100%,$AQ2<=30%),$AB2*1.2,$AB2*0.9)
AX13	AX13	=IF(AND($AC2="exact",$AB13<=$AR13,$AI13>=500,$AP13<=100%,$AQ13<=30%),$AB13*1.2,$AB13*0.9)
AX14	AX14	=IF(AND($AP14<=100%,$AQ14<=30%),$AB14*1.2,$AB14*0.9)