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