Interest amounts
 

Hi i wonder if anyone out there can help me I have an exam on wednesday and
am confused about one area if

If I have a rate of 5% in cell C1 and a investment amount of 5,000,000 in
cell C2 and then a interest amount of 250,00 in C3, then i have a table of
varing interest amounts in B7:B22 how can i work out the formula in C6 and
copy it down the rest of the table.

I hope this is clear to someone

Many thanks
Debbie

Interest amounts
 

What do you want the formula in C6 to calculate? HTH Otto
"duckie71" <u24916@uwe wrote in message news:6450fb7c7a8c6@uwe...
Hi i wonder if anyone out there can help me I have an exam on wednesday
and
am confused about one area if

If I have a rate of 5% in cell C1 and a investment amount of 5,000,000 in
cell C2 and then a interest amount of 250,00 in C3, then i have a table of
varing interest amounts in B7:B22 how can i work out the formula in C6 and
copy it down the rest of the table.

I hope this is clear to someone

Many thanks
Debbie

Interest amounts
 

Sorry I didn't explain it very well,

the interest amount is 250,000 and the table is varing % rates and i want to
work out what the interest amount would be dependant on the % rate.

Otto Moehrbach wrote:
What do you want the formula in C6 to calculate? HTH Otto
Hi i wonder if anyone out there can help me I have an exam on wednesday
and
[quoted text clipped - 9 lines]
Many thanks
Debbie

Interest amounts
 

We still have a problem. Tell me what is constant and what is variable.
You say that the interest amount is 250,000 then you say you want to
calculate the interest amount as a function of interest rate. If the
interest amount is 250,000 then the interest amount is 250,000. Period. If
the interest amount is 250,000 for a 5% interest rate, then the interest
amount is 250,000 for only that one value of interest rate. I will assume
that the investment is a constant at 5 million and you want a formula to
calculate the interest amount for varying interest rates.
If B1 holds the investment amount, B6 and down holds the varying interest
rates, then put this formula in C6 and drag it down as far as the interest
rates go:
=$B$1*B6

HTH Otto

"duckie71" <u24916@uwe wrote in message news:64527ea89023c@uwe...
Sorry I didn't explain it very well,

the interest amount is 250,000 and the table is varing % rates and i want
to
work out what the interest amount would be dependant on the % rate.

Otto Moehrbach wrote:
What do you want the formula in C6 to calculate? HTH Otto
Hi i wonder if anyone out there can help me I have an exam on wednesday
and
[quoted text clipped - 9 lines]
Many thanks
Debbie

Interest amounts
 

Debbie
Note that for the formula to work, the interest rates must be shown as
decimals, like .05, .06 etc. Or the cells must be formatted as Percentage
and the entries are then 5, 6, etc. HTH Otto
"duckie71" <u24916@uwe wrote in message news:64527ea89023c@uwe...
Sorry I didn't explain it very well,

the interest amount is 250,000 and the table is varing % rates and i want
to
work out what the interest amount would be dependant on the % rate.

Otto Moehrbach wrote:
What do you want the formula in C6 to calculate? HTH Otto
Hi i wonder if anyone out there can help me I have an exam on wednesday
and
[quoted text clipped - 9 lines]
Many thanks
Debbie