Forum Discussion

vaw1969's avatar
vaw1969
Copper Contributor
Oct 31, 2020

formula help please

i need a formula please if someone can help   my columns are below transaction description Debit  Credit   Balance    Account transfers Stock & dog purchases animal health AT   ...
excel
Ramiz_Assaf's avatar
Ramiz_Assaf
Iron Contributor
Oct 31, 2020

vaw1969 

 

I want to help you, however it is not clear. 

Can you please give an example and explain it a bit better. it is not hard what you are asking, but I need to be sure that I undersood it correctly.

  • vaw1969's avatar
    vaw1969
    Copper Contributor
    Oct 31, 2020

    Ramiz_Assaf this is an exert from my spreadsheet

    transaction description Debit/Credit  Balance  Account transfers Stock & dog purchasesanimal healthfuelbreaking & trainingvehicle expensesVehicle paymentdrawingsBank chargesinterest
       $                229.10           
                  
                  
    AT $                 50.00 $                279.10  $               50.00         
    AT $                 50.00 $                329.10  $               50.00         
    AT $                 50.00 $                379.10  $               50.00         
    AT $                 50.00 $                429.10  $               50.00         
    INT $                   0.12 $                429.22           $                 0.12
    AT $                 50.00 $                479.22  $               50.00         

     

    What I am wanting to do is have a formula that will automatically fill the Ledger columns with the figures from the debit credit column when I add the description abbreviation.  ie:  AT stands for account transfers so all the debit/credits that are an AT description will auto fill into the account transfers column, and the INT to interest column (rather than me having to manually copy and paste the figure into that column).  

     

    I hope this is clearer and allows you to help me with a formula to do this.

     

    Thanks

     

Resources