Hi,

Try this

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

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"marsjune68" wrote:

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.