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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top