bballsmurf4
New Member
- Joined
- Dec 15, 2011
- Messages
- 1
Need help with a formula on excel that I can't seem to get. Basically I trying to create a formula where the monthly interest payment is automatically calculated based in what range the monthly billing falls into, as well as what type payment it is (E33). But I have several variables. Is this possible in Excel -- if so PLEASE HELP! Trying to write something like this...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
If E33=1<o
></o
>
AND C36 (Monthly Billing) is GREATER THAN $50 and LESS THAN $1501, THEN C37(Monthly Interest Payment) is 20% of the Monthly Billing (C36)<o
></o
>
OR if E33=1<o
></o
>
AND C36 (Monthly Billing) is GREATER THAN $1500 and LESS THAN $3001, THEN C37(Monthly Interest Payment) is 15% of the Monthly Billing (C36)<o
></o
>
OR if E33=1<o
></o
>
AND C36 (Monthly Billing) is GREATER THAN $3000 and LESS THAN $6001, THEN C37(Monthly Interest Payment) is 10% of the Monthly Billing (C36)<o
></o
>
OR if E33=1<o
></o
>
AND C36 (Monthly Billing) is GREATER THAN $6000 and LESS THAN $10,001, THEN C37(Monthly Interest Payment) is 10% of the Monthly Billing (C36)<o
></o
>
OR if E33=1<o
></o
>
AND C36 (Monthly Billing) is GREATER THAN $10,000, THEN C37(Monthly Interest Payment) is 5% of the Monthly Billing (C36)<o
></o
>
<o
></o
>
If E33=2<o
></o
>
AND C36 (Monthly Billing) is GREATER THAN $50 and LESS THAN $3000, THEN C37(Monthly Interest Payment) is 30% of the Monthly Billing (C36)<o
></o
>
OR if E33=2<o
></o
>
AND C36 (Monthly Billing) is GREATER THAN $1500 and LESS THAN $3001, THEN C37(Monthly Interest Payment) is 15% of the Monthly Billing (C36)<o
></o
>
OR if E33=2<o
></o
>
AND C36 (Monthly Billing) is GREATER THAN $3000 and LESS THAN $6001, THEN C37(Monthly Interest Payment) is 5% of the Monthly Billing (C36)<o
></o
>
<o
></o
>
If E33=3<o
></o
>
AND C36 (Monthly Billing) is GREATER THAN $50, THEN C37(Monthly Interest Payment) is 10% of the Monthly Billing (C36)<o
></o
>




<o


If E33=1<o


AND C36 (Monthly Billing) is GREATER THAN $50 and LESS THAN $1501, THEN C37(Monthly Interest Payment) is 20% of the Monthly Billing (C36)<o


OR if E33=1<o


AND C36 (Monthly Billing) is GREATER THAN $1500 and LESS THAN $3001, THEN C37(Monthly Interest Payment) is 15% of the Monthly Billing (C36)<o


OR if E33=1<o


AND C36 (Monthly Billing) is GREATER THAN $3000 and LESS THAN $6001, THEN C37(Monthly Interest Payment) is 10% of the Monthly Billing (C36)<o


OR if E33=1<o


AND C36 (Monthly Billing) is GREATER THAN $6000 and LESS THAN $10,001, THEN C37(Monthly Interest Payment) is 10% of the Monthly Billing (C36)<o


OR if E33=1<o


AND C36 (Monthly Billing) is GREATER THAN $10,000, THEN C37(Monthly Interest Payment) is 5% of the Monthly Billing (C36)<o


<o


If E33=2<o


AND C36 (Monthly Billing) is GREATER THAN $50 and LESS THAN $3000, THEN C37(Monthly Interest Payment) is 30% of the Monthly Billing (C36)<o


OR if E33=2<o


AND C36 (Monthly Billing) is GREATER THAN $1500 and LESS THAN $3001, THEN C37(Monthly Interest Payment) is 15% of the Monthly Billing (C36)<o


OR if E33=2<o


AND C36 (Monthly Billing) is GREATER THAN $3000 and LESS THAN $6001, THEN C37(Monthly Interest Payment) is 5% of the Monthly Billing (C36)<o


<o


If E33=3<o


AND C36 (Monthly Billing) is GREATER THAN $50, THEN C37(Monthly Interest Payment) is 10% of the Monthly Billing (C36)<o

