+ Reply to Thread
Results 1 to 2 of 2

Credit and Debit formating

  1. #1

    Credit and Debit formating

    I have workbook that has one tab that pending credits and charges are
    entered by associates who are not Excel suavy. That information is linked to
    a cell for reconcilation. The purpose is to figure a inventory.

    How it works is
    actual count plus pending items to come up with a new inventory balance. The
    problem is I need to add back into the inventory the credits and take out
    the charges. Do to the fact that these credit debits are entered in the same
    place. What I am trying to do is convert the credit to charges and subtract
    the debit (opposite of value). Is there a formula that can do this?

  2. #2
    Registered User
    Join Date
    Can you post the file or an example of how the debits/credits are displayed?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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