View original (French)

Auto-increment not working

Mich49_1890 -  
Le Pingou Posted messages 12275 Registration date   Status Contributor Last intervention   -

Hello,

I have a problem with an EXCEL table - Office Family 2019. Could you help me solve my issue?
I have a column (C) where I want to automatically add the previous values to create a running total.

Specifically:

I have a first line with a credit balance of 4787.20 in C1

Then a second line with values: A2 (nothing); B2=53.91 (credit)
A column C where I want to see appear in C2: C1+B2 (53.91 credit); C3 = C2-A3 (8.95 debit); C4 = C3+A4

I put a calculation formula in column C that represents the balance.
Previously, I would select the cells from columns A and B and C, then drag down with the small cross in the bottom right corner. The formula would adapt and the total would be updated automatically.

This time, however, when I enter 53.91 (Cr) in B2 and 8.95 (Db) in A3 and 45.00 (Db) in A4 and I drag down, it increments the cell B2, and in B4 we find an amount of 54.91 in the credit. The amount of 45.00 that I entered as a debit in A4 is removed. The calculation does not take into account my formula entered in C.

However, with the formula, when I enter the amounts gradually, the balance is correct but when I drag down with the small cross, it results in the problem described above.

I can't do a copy/paste of the result. The exact final balance should be 4787.16 and with this software issue, it is 4887.07, which is incorrect.

Thank you in advance for your help,

Best regards


4 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     

    Hello

    I don't quite understand your approach

    If you have debits in column A and credits in column B, the formula in C should be (in C2) =C1+B2-A2. You just need to drag this formula down

    Note: If you want to prepare column C in advance, the formula in C2 will be =IF(COUNT(A2:B2),C1+B2-A2,"")

    If this doesn't address your issue, could you send a snippet of your file to cjoint.com and include the resulting link in your next message? Don't forget to add explanations and examples of the expected results
    1) Go to http://cjoint.com/
    2) Click on [Browse] to select your file
    3) Scroll down to the bottom of the page to click on [Create Cjoint link]
    4) After a few seconds, the second page will display the link
       in blue underlined; select it and click "Copy"
    5) Return to your conversation on CCM, and in your reply message, click "Paste".

    Best regards

    0
  2. JCB40 Posted messages 3060 Registration date   Status Member Last intervention   479
     

    Good evening

    To be tested for placement in C2 and stretched downwards

    =IF(A2+B2=0,"",SUM(C1+B2-A2))

    Best regards

    0
  3. Le Pingou Posted messages 12275 Registration date   Status Contributor Last intervention   1 478
     

    Hello,

    In summary, see image:

    Regards.
    The Pingou

    0
  4. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     

    Hello Mich49_1890.

    I want to show in C2: C1+B2 (53.91 credit); C3 = C2-A3 (8.95 debit); C4 = C3+A4:incorrect, it’s C4 = C3-A4

    The exact final balance must be 4787.16 and with this computer problem it is 4887.07, so incorrect:once the formula in C4 is corrected, we indeed find 4,787.16!

    The formulas from ccm81 and JCB40 are the ones you can use.

    It’s nice, retirement! Especially in the Antilles...
    Raymond (INSA, AFPA)

    0
    1. Le Pingou Posted messages 12275 Registration date   Status Contributor Last intervention   1 478
       

      Hello Raymond,

      And mine too.

      Best regards.

      0