Results 1 to 3 of 3

Index, Match, If Problems (Fin Statement)

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2017
    Location
    Indonesia
    MS-Off Ver
    MS Office 2013
    Posts
    17

    Index, Match, If Problems (Fin Statement)

    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
    Attached Files Attached Files
    Last edited by n4t4nes; 12-19-2018 at 02:24 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Problems with INDEX, MATCH, MATCH returning incorrect values
    By Paul103 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2018, 05:16 PM
  2. Problems applying INDEX-MATCH-MATCH function on other data
    By LennartB in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2015, 05:33 AM
  3. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  4. problems with index/match
    By FFFran in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2013, 01:29 PM
  5. Index Match Problems
    By Zimbo in forum Excel General
    Replies: 3
    Last Post: 03-02-2011, 07:08 AM
  6. INDEX and MATCH problems
    By protocoledu in forum Excel General
    Replies: 2
    Last Post: 05-20-2009, 11:22 AM
  7. Various index match problems
    By Joe Pineapples in forum Excel General
    Replies: 3
    Last Post: 05-03-2009, 06:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1