product function

  1. S

    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...
  2. M

    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)...
  3. G

    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...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top