Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel formula needed to amounts into one column pulling from 2 col
I need to consolidate data into one column from two columns. Data in
accounting figures in columns debit & credit. Need column from debit to be positive and credit to be negative joined in one column. Quick formula for this? |
#2
|
|||
|
|||
Scott,
Where column A has credits, and B has debits, and both are entered as positive numbers, something like =IF(A1<"",A1,-B1) would convert to a single column style, where credits are positive and debits are negative. Still, you would need to give a short example for us to be sure of writing a workable formula. HTH, Bernie MS Excel MVP "Scott" wrote in message ... I need to consolidate data into one column from two columns. Data in accounting figures in columns debit & credit. Need column from debit to be positive and credit to be negative joined in one column. Quick formula for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
Help, Excel Formula Needed -- Urgent | Excel Worksheet Functions | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |