Change dollar value(+credit) to (-)debits

ilmconsultant 

I am not sure what it means to turn a credit into a debit so maybe this is not the answer you require.  However, if you have unsigned lists of credits and debits they may be combined into a single transaction amount using the formula

transaction
= credit - debit

This does assume that the array of credits has the same number of rows.