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,

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


"lsmith" <lsmith.23nd2o_1140639009.8904@excelforum-nospam.com> wrote in message
news:lsmith.23nd2o_1140639009.8904@excelforum-nospam.com...
>
> 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
>