| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| to compute interest rate from principal and interest amount | Excel Discussion (Misc queries) | |||
| Interest Functions | Excel Worksheet Functions | |||
| How do I calc interest when using multiple dates within a given ye | Excel Worksheet Functions | |||
| Function help with Calculating Interest for two different investme | Excel Worksheet Functions | |||
| Keeping track of loan payments and interest | Excel Discussion (Misc queries) | |||
Hybrid Mode
