Need help using multiple conditions to create formula

[adtn98]

Hi,

I'm trying to find the correct functions/formulas to use that would increase a bid based on certain criteria. My columns are (A)Bid Amount (B)Keyword (C)Orders (D)Average Cost of Sales (ACoS%). Using these numbers I'd like to be able to adjust the bid amount based on the following criteria:


IF:

<7% ACoS = Increase Bid by 2.5x
<7-10% ACoS = Increase Bid by 2x
<10-15% ACoS & Orders >5 = Increase Bid by 1.5x
<10-15% ACoS & Orders <5 = Increase Bid by 1.2x

I'm having trouble figuring out how to do this based on the multiple criteria especially on how to create changes based on both ACoS and orders. I'd really appreciate if someone could help me if they had any insight into this.

Thanks!

[CAABYYC]

following formula will show you 1.2x if order is equal to 5

A2=IF(D2<0.07,2.5,IF(AND(D2>=0.07,D2<0.1),2,IF(AND(D2>=0.1,D2<0.15),IF(C2>5,1.5,1.2),"/")))

[adtn98]

Wow! Thanks so much! That's it! It works perfectly.