# product function

1. ### Calculating 1 / 3 / 5 year Returns on a table that varies in length.

Hi, I have a table of monthly performance data where each new month the previous month's performance is annotated. I'm looking to use a formula that calculates the 1, 3, 5 year returns automatically and allows for the fact that the table or performance data increases each month. This formula...
2. ### Translate (PRODUCT(1+A1:A3/100)-1)*100 Formula

An existing spreadsheet has a formula which needs to be implemented in SQL. The user note indicates 3 months compounding formula where each rows stores 1 month of data. (PRODUCT(1+A1:A3/100)-1)*100 The formula does not have curly braces around it to make it an array formula. I tried to...
3. ### Calculating investment returns using "PRODUCT" function?

Hi, I'm getting 2 slightly different answers with my returns, why???? Initial investment (say) \$2,000,000 % monthly returns(1-4): 0.65%, -0.6%, 0.87%, -9.36%. If I use the "PRODUCT" function to obtain an answer to my overall monthly returns its -8.53% Actual monthly returns (1-4)...
4. ### Product Function Over Dynamic Range

Hi All Please can anyone help me creat a macro that can do the following: given a data set a b c 01-Jan 2010 5 10 15 01-Feb 2010... 9 5 10 01-March.... 4 6 4 on this set, I can calculate 3 cummulative return, next month I will add May and then wish to calculate 3 cummulative retun up to...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back