How to Split Net Values into Debits and Credits in Excel
A common situation I see is a spreadsheet with a column that has both negative and positive values, which needs to be split into debits and credits. It's pretty easy, but you might not have considered that there are a couple ways to approach this problem. Here, I show you a couple methods... and a bonus tip at the end.