Wednesday May 25, 2022 09:44

Exported mint transactions manipulation to change debit numbers to minus.

Posted by Ureviews

Print This Post Print This Post

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.

eXTReMe Tracker