cumulative formula

  1. T

    Error on formula (compound percentage)

    Hi, new on the forum, would appreciate some help, I've spent 7 hours trying to figure this out :banghead: I'm trying to insert a formula in excel for Mac 2011& 2016 The formula is: =IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) Keeps giving me an error. I'm tryint to reconstruct the...
  2. A

    Cumulative sales Forecast Formula

    I have a year end sale figure of £80,000 and want to divide this between 12 months in way that starts from Jan to Dec, and the Jan Sale not to be less than £4,000 and each month the sale increase slightly with a few fluctuations in Sep, Feb and March when there is seasonality and the sales are...
  3. D

    Formula to keep a running total

    I'm trying to create a formula that keeps a running total. So it will look in the cell to the left and if there is a value greater than zero it looks for the next cell above with a value greater than zero and adds the two together. If there is no value greater than zero above it takes just the...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top