Wednesday May 25, 2022 09:44
Exported mint transactions manipulation to change debit numbers to minus.
![Print This Post Print This Post](https://www.extrafudge.com/site/wp-content/plugins/wp-print/images/print.gif)
After exporting to excel select an empty column and put this in the first cell Assuming D column has the amounts and E column has the debit/credit
=if(E1=”debit”,-D1,D1)
Then just pull down the box to replicate this formula on the rest of the rows.
If this helped you please please consider buying me coffee! Thanks in advance!
- Category: How-To
- No Comments
Recently Commented