I have two columns of dollar data, one credits, one debits. If I just AUTOSUM the rows, the result appears in a single column. I would like to place a NEGATIVE (credit) result in one column, and a POSITIVE (debit) result in another column. Zero result (i.e., debits/credits canceling out) should NOT appear (as 0) but as blank in both.
Perhaps you have something along the lines of the attached in mind?
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
Thanks, Brendan, but column C would be -2, not -6. I need the SUM of A and B in the appropriate column. If negative number, then in C, if positive, in D.
Ah, I see what you mean now. In that case,
in Column C, and
Please Login or Register to view this content.
in Column D should give your desired result.Please Login or Register to view this content.
Hope this helps.
Hi,
Following on your earlier response, in an income expense spread sheet, I have four columns, date, description, debit and credit, with the number of rows unknown yet. At the last entry of the month, I would like to have the final net figure calculated from the debit and credit entries made in separate columns. Grateful for your help on the appropriate formula.
Cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks