Results 1 to 6 of 6

Debit/Credit Journal Formula

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Debit/Credit Journal Formula

    Hi,

    I have had help on different posts previously with auto populating a journal and needing it to determine the correct side of the journal based on a “+” and “-“.

    I need the same but this time with a different data set that is in a different layout.

    The data is on the sheet “Monthly Data” in the cell columns H:T. I need certain row data (highlighted in red) pulled from the Monthly Data sheet onto the monthly journal. The main compliation would be which side of the journal to post “+” is debit and “-“ is credit.

    Can someone help please?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. debit-credit
    By tiki33 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2014, 03:13 AM
  2. Replies: 4
    Last Post: 01-18-2014, 03:24 AM
  3. Debit credit formulas
    By SAMEEP in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 11-08-2011, 01:13 PM
  4. Create two line journal entry from one line, two different column for debit & credit
    By ditto135 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2011, 03:01 PM

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