Assuming you have a header row with cell A1 labeled Amount and Cell B1
labeled fee, Cell C1 labeled Range of loan (c2= 1,000 to 10,000, c3=10,000 to
1,000,000 and c4=1,000,000 to 10,000,000), try the following:

Enter the loan amount in Cell A2.

In Cell B2 enter this formula:
=IF(A2=10000,57.5,IF(AND(A2=1000,A2<10000),A2/1000*5.75,""))

In Cell B3 enter this formula: =IF(A21000000,
500,IF(AND(A2=100000,A2<1000000),(A2-100000)/1000*5,""))

In Cell B4 enter this formula:
=IF(AND(A2=1000000,A2<=10000000),(A2-1000000)/1000*3,"")

Cell B2 will show the fee for the portion of the loan from 1,000 to 10,000;
Cell B3 will show the fee for the portion of the loan from 10,000 to
1,000,000; and Cell B4 will show the fee for the portion of the loan from
1,000,000 to 10,000,000. You can create a sum in cell B5 to give you the
total fee.

"lsmith" wrote:


Dear SVC: This is part of the problem I'm having. As a new user, I
don't know WHICH parts to take out of the equation for each separate
query. I need three separate formulas.


--
lsmith
------------------------------------------------------------------------
lsmith's Profile: http://www.excelforum.com/member.php...o&userid=31824
View this thread: http://www.excelforum.com/showthread...hreadid=519523