Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
debits and credits in one column
Hello:
I have a financial spreadsheet containing journal entries and, of course, one column has debits and the other has credits. The debit column and the credit column have to be in one column and the credits will need the negative sign placed in front within that same column to make the number a negative obviously. What formula can I use to place these two fields like these into one column with a negative sign in front of the the credits within that one column? Thanks! childofthe1980s |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
debits and credits in one column
The formula example below assumes debits in A3 and credits in B3
="-"&TEXT(A3,"#.00")&" "&TEXT(B3,"#.00") If you want a currency format for the values change the "#.00" formatting to "$#,##0.00" to get punctuated values with 2 decimals -- Kevin Backmann "childothe1980s" wrote: Hello: I have a financial spreadsheet containing journal entries and, of course, one column has debits and the other has credits. The debit column and the credit column have to be in one column and the credits will need the negative sign placed in front within that same column to make the number a negative obviously. What formula can I use to place these two fields like these into one column with a negative sign in front of the the credits within that one column? Thanks! childofthe1980s |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
debits and credits in one column
Hi
I read the request slightly differently. Assuming the Journals have a description in column A, Debit amount in B and Credit amount in C and assuming they take the normal form where there will not be a value in both column B and co,um C for the same line entry, then in column D =B1+C1*-1 will get all the values to a single column wit the appropriate sign. -- Regards Roger Govier "Kevin B" wrote in message ... The formula example below assumes debits in A3 and credits in B3 ="-"&TEXT(A3,"#.00")&" "&TEXT(B3,"#.00") If you want a currency format for the values change the "#.00" formatting to "$#,##0.00" to get punctuated values with 2 decimals -- Kevin Backmann "childothe1980s" wrote: Hello: I have a financial spreadsheet containing journal entries and, of course, one column has debits and the other has credits. The debit column and the credit column have to be in one column and the credits will need the negative sign placed in front within that same column to make the number a negative obviously. What formula can I use to place these two fields like these into one column with a negative sign in front of the the credits within that one column? Thanks! childofthe1980s |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change credits to debits in Excel | Excel Discussion (Misc queries) | |||
Using Sumif with debits & credits | Excel Discussion (Misc queries) | |||
vertical lines between credits and debits | New Users to Excel | |||
formula for debits and credits in EXCEL spreadsheet | Excel Worksheet Functions | |||
Increment array for debits and credits | Excel Programming |