Help Needed with Finding a Function

  • Thread starter Thread starter lsmith
  • Start date Start date
L

lsmith

I'm a new user to Excel, although I did attend a 3-level instructional
class for the program at a computer instructional center. I'm working
on a modelling exercise, and need to know which function to use when
trying to figure out the following financial query:

If I have a loan amount for $100K, and am trying to figure out how much
the title costs are for the following line items, WHAT function is
this?

$5.75 per $1,00 for $1m to $100m = ___________
$5.00 per $,100 for $100m to $1mm = __________

These queries should be linked to the orginal loan amount, so this
template can be utilized with different loan amounts.


Many thanks.
 
lsmith,

Assuming $5.75 per $1,000 for 1,000 to 100,000 and $5.00 per $1,000 for 100,000 to 1,000,000+, with
the amount in cell A1:

=IF(A1>0,5.75*(MIN(A1,100000)/1000) + 5*(MAX(0,A1-100000)/1000),0)

HTH,
Bernie
MS Excel MVP
 
Back
Top