+ Reply to Thread
Results 1 to 3 of 3

Multiple logic functions in one cell

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Multiple logic functions in one cell

    I am new to forums in general and this one in particular. I have been working hours on a spreadsheet for construction work in progress. My hang up is the adjusting journal entry. I need the columns to undo the previous entry and add the new entry, but only showing the difference between the 2. This requires getting columns to consider prior entries. I am SO confused. I understand the accounting, but can't figure out how to tell excel what I want.

    WIP Calculator.xlsx

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Multiple logic functions in one cell

    I did not see any tabs or headers labeled Journal Entry.

    Can you please provide more direction, and show an example of what your expected result would look like? (Maybe a before and after?)

  3. #3
    Registered User
    Join Date
    10-08-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Multiple logic functions in one cell

    The tab is Accounting GJE (General Journal Entry).
    As an FYI, some of the info is coming from the WIP Report tab.
    The end result is to equal the "Resulting Balance Sheet Account Total"
    With journal entries you have adding subtracting on "both sides" (double entry accounting).
    So, the first thing is for the DR and CR columns to be equal. The Income row is accurate and does not need help. It's the balancing entry of the WIP Asset and WIP liability that needs help. First if the Income is on the DR side, then the resulting Asset or Liability must be on the CR side...and the A+L must equal Income. BUT, you have to take into consideration the previous months entry.
    I have put in the correct numbers for February. But the calculations I used do not work for other months. So just use them as an example of what it should look like.
    Does any of this make sense?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Text in a single cell based on logic of multiple other cells
    By dtrimble in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2013, 01:33 AM
  2. can i have multiple logic functions in one cell?
    By 70gofast in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2012, 08:51 PM
  3. [SOLVED] Financial Formula Data Processing - multiple logic functions in one
    By spikesplayfood in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-11-2012, 02:21 PM
  4. Replies: 3
    Last Post: 08-29-2011, 12:42 AM
  5. Logic for Placing Multiple field Returns in a Cell
    By SCHNYDES in forum Excel General
    Replies: 4
    Last Post: 10-21-2005, 08:05 PM

Tags for this Thread

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