Excel formula needed to amounts into one column pulling from 2 col

[Scott]

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?

[Bernie Deitrick]

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" <Scott@discussions.microsoft.com> wrote in message
news:5C765B56-D1E6-4C74-B6E5-3341BA4A3DBB@microsoft.com...
> 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?