Dear all Excel friend
I am not expert in Excel and maybe my English is bad for explain my problem.
I am learning Excel from this Forum and try to make formula
My first problem,
If i choose A, then it will show it,s Post, wether Debet or Kredit
When it show Debit, then every Debit Value is + and Kredit Value is (-)
When it show Kredit, then every Kredit Value is + and Debit Value is (-)
Example:
GL_Post Accounts[Post] Accounts[Debit] Accounts[Kredit] Beg. Balance Goal
Debit Debit 5000 0 5000
Debit Debit 0 5000 -5000
Kredit Kredit 5000 0 -5000
Kredit Kredit 0 5000 5000
My formula is not working, i am become more confuse lol
My second problem,
I want to make a Balance in table,
First Balance row = Beg. Balance Saldo + (if "Post" = Debit, Debit Value +; Kredit Value -) (else, Debit Value -; Kredit Value +)
Second balance row (and other) = last balance + (if "Post" = Debit, Debit Value +; Kredit Value -) (else, Debit Value -; Kredit Value +)
I will upload my dummy, because i am not good at explains
Thanks for your attention All
Bookmarks