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,12 1,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.