| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dont know Excel Function
Dear All,
I have a table as follows: Jul-04 1.0000 Aug-04 1.0025 Sep-04 1.0038 Oct-04 1.0046 Nov-04 1.0048 Dec-04 1.0110 Jan-05 1.0182 Feb-05 1.0261 Mar-05 1.0298 Apr-05 1.0336 May-05 1.0369 Jun-05 1.0403 Jul-05 1.0424 Aug-05 1.0450 Sep-05 1.0466 Oct-05 1.0480 Nov-05 1.0490 Dec-05 1.0525 Jan-06 1.0567 Feb-06 1.0621 Mar-06 1.0666 Apr-06 1.0699 May-06 1.0726 Jun-06 1.0747 Jul-06 1.0771 Aug-06 1.0814 Sep-06 1.0845 Oct-06 1.0861 Nov-06 1.0858 Jul-04 as Base Month. What function to calculate that monthly escallation based on 3 or 3.5% yearly (I am not which one of the rate)? Thank you for your help. Brgds,andri |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dont know Excel Function
Hello,
An example for 3% p.a.: monthly rate =RATE(12,0,-1,1+3%) which is equal to =(1+3%)^(1/12)-1 HTH, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
| How do i execute a VBA function by clicking on an excel cell? | Excel Discussion (Misc queries) | |||
| Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
