If Statement

[mj1000]

Not sure where to do from here. If figured out my formula to return certain cells if they meet the <= criteria. =IF(G25<=50,$E$3,IF(G25<=100,$E$4,IF(G25<=200,$E$5,IF(G25<=500,$E$6,IF(G25<=1000,$E$7,$E$8)))))

I also need to multiple the returned value by either 1.1 or 1 depending on the criteria in B25. How do I add this If statement to my existing statement

IF(B25=D9,*1.1,*1)

I dont even know if its possible.

Thanks in advance for all your help.

 

[barry houdini]

You can pretty much just multiply those, i.e. like this

=IF(G25<=50,$E$3,IF(G25<=100,$E$4,IF(G25<=200,$E$5,IF(G25<=500,$E$6,IF(G25<=1000,$E$7,$E$8)))))*IF(B25=D9,1.1,1)

 

[mj1000]

Doh! Thanks so much. Appreciate your time.