if statement issues.

[marsjune68]

I want to write a if statement but can not figure it out.
Here is the formula I have.
=IF(F36<=200,SUM(F36),(L34))

Note L34 = $200.00 This can be adjusted to any dollar amount.

c36 contains 1,2 1=used 2=new
d36 is the age in days
e36 is a dollar amount
f36 is the commision this is the formula
=IF(C36=1,IF(E36<=99.99,25,E36*LOOKUP(D36,{0,61,121,181},{0.1,0.15,0.2,0.25})),IF(E36<=99.99,LOOKUP(D36,{1,121,271},{25,50,100}),IF(AND(D36<16,E36*5%>200),200,E36*LOOKUP(D36,{0,61,121,271},{0.1,0.15,0.2,0.25}))))

h36 this is the formula
=IF(F36<=200,SUM(F36),(L34))

L34 is my max amount=$200.00
I need H36 to only return $200.00 if C36=2 and D36= is between 0-60 and f36
is above the value set in L34. Other wise return the value in f36.
Or is there an easier way to do this?

Thank you in advance.

 

[marsjune68]

I am trying this fromula in H36
=IF(F36<=200,SUM(F36),(L34)),IF(C36=2,D36<=60) but it is not working Help
please!!!!!!!!!!!!!!!!!!!

 

[Shane Devenshire]

Hi,

Try this

=IF(AND(C36=2,D36<=60,D36>=0,F36>L34),200,F36)

However, I need to concede that I'm not entirely clear on what you want to do.