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.

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!!!!!!!!!!!!!!!!!!!

"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.

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.