Interest amounts

[duckie71]

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

 

[Otto Moehrbach]

What do you want the formula in C6 to calculate? HTH Otto

 

[duckie71]

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.

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

 

[Otto Moehrbach]

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

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.

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

 

[Otto Moehrbach]

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

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.

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