Help Needed with Finding a Function
 

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
------------------------------------------------------------------------
lsmith's Profile: http://www.excelforum.com/member.php...o&userid=31824
View this thread: http://www.excelforum.com/showthread...hreadid=515487

Help Needed with Finding a Function
 

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(A10,5.75*(MIN(A1,100000)/1000) + 5*(MAX(0,A1-100000)/1000),0)

HTH,
Bernie
MS Excel MVP


"lsmith" wrote in message
...

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
------------------------------------------------------------------------
lsmith's Profile: http://www.excelforum.com/member.php...o&userid=31824
View this thread: http://www.excelforum.com/showthread...hreadid=515487