Thanks for chiming in here @Caroleen and glad that helped you @gerstbergerconstruct
Would someone be helpful with formula guidance if you have a column that says credit or debit and a column with the absolute values. How do you get the values to show negative?
If your (always positive) amount were in column C and your credit/debit indicator were in column D, you could do something like =IF(D2="Credit",C2,-C2)
to set the polarity.