formulae and functions

%3CLINGO-SUB%20id%3D%22lingo-sub-1513838%22%20slang%3D%22en-US%22%3Eformulae%20and%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1513838%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20add%20credit%20to%20previous%20balance%20and%20subtract%20debit%2C%20to%20get%20actual%20balance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1513838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1514182%22%20slang%3D%22en-US%22%3ERe%3A%20formulae%20and%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514182%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F724581%22%20target%3D%22_blank%22%3E%40sandy1968%3C%2FA%3E%26nbsp%3BCreate%20two%20columns%20of%20Debit%20and%20Credit%20and%20In%20the%20third%20column%20Substract%20sum%20of%20debit%20column%20from%20sum%20of%20credit%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20liked%20my%20solution%20please%20accept%20my%20solution%20as%20an%20official%20answer%20and%20follow%20me%20on%20my%20youtube%20channel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D4SlI8HOGvlM%26amp%3Bt%3D3s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D4SlI8HOGvlM%26amp%3Bt%3D3s%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I want to add credit to previous balance and subtract debit, to get actual balance.

1 Reply
Highlighted

@sandy1968 Create two columns of Debit and Credit and In the third column Substract sum of debit column from sum of credit column.

 

If you liked my solution please accept my solution as an official answer and follow me on my youtube channel

 

https://www.youtube.com/watch?v=4SlI8HOGvlM&t=3s

Hi Guys, I have come up with the second part of Invoice Automation through Excel video. This Utility will help you to generate Invoice as shown in previous v...