View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
childothe1980s childothe1980s is offline
external usenet poster
 
Posts: 23
Default 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