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