Nested IF statement (IF that can do what I am expecting)

[T3as3r22]

In Column 'I' I would like to have the following.

=IF(A2<E2,IF(B2<500,IF(C2>50%,IF(D2<50%,IF(A2<I2%,A2*"1.25"),OR(A2*"0.90")))) - But this is not working. Missing something. Can someone please help?

TIA.

 

[Alex Blakenburg]

Please put into words what you are trying to do.

In Column 'I' I would like to have the following.

You refer to column "I" but did you mean J
What result were you expecting ?
This A2<I2% looks like it says the lettter I then 2% is it meant to be a 1 as in Twelve percent.

Here a guess.

Book1
	A	B	C	D	E	F	G	H	I	J
1	Bid	Impression	Conversion Rate	Acos	CPC	ROAS	CPA	AoV	Affordable Bids(Max)	Value Here
2	0.48	56	200%	0.35%	0.48%	289.58	0.48	69.5	27.8	0.432
Sheet1

Cell Formulas
Range	Formula
J2	J2	=IF(AND(A2<E2, B2<500, C2>50%, D2<50%, A2<12%), A2*1.25, A2*0.9)

 

[T3as3r22]

Hi Alex,
Thanks a lot.
Sorry, I added one column in middle later and forgot to send that screenshot. But yes, this helped, twisted a bit as per my requirement and it worked.
Regards,
T3as3r22

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.