I have quickly put together the the fomula below which seems to provide for
all three scenarios in a single cell (you'll need to verify it, I did this
quickly), assuming the following conditions.

1. For 10,000 to 100,000 there is a straight fee of $5.75 per $1,000.
2. For 100,000 to 1,000,000 the fee includes the maximum fees for #1 plus a
fee of $5.00 per $1,000 for amounts in excess of $100,000.
3. For 1,000,000 to 10,000,000 the fee includes the maximum fees in #2 plus
a fee of $3.00 per $1,000 for amounts in excess of $1,000,000 but less than
or equal to $10,000,000.

If you need calculations in separate cells, you can cut and paste the parts
need from the equation.

Here is my formula:
=IF(AND(1000<=A1,A1<100000),A1/1000*5.75,IF(AND(100000<=A1,A1<1000000),(10*5.75)+ (A1-10000)/1000*5,IF(AND(1000000<=A1,A1<=10000000),(10*5.75)+ (999.99999*5)+(A1-1000000)/1000*3,"")))

"lsmith" wrote:


I need verfication of the formulas for the THREE SEPARATE queries below.
I've received a previous answer, but the formula given combined the two
examples. I cannot have ONE formula for these queries, they HAVE to be
separate. They also need to link to the original loan amount, so if
this changes, the other amounts will change in accordance to that
original amount.

If the orginal loan amount is $100,000.00, what would the formula be to
get the amount for:

(1) $5.75 per $1,000 from $1,000 to $100,000 = ____?____

for this amount?

(2) $5.00 per $1,000 from $100,000 to $1,000,000 = ____?____

for this amount?

(3) $3.000 per $1,000 from $1,000,000 to $10,000,000 = ____?____




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