{"id":2993,"date":"2022-05-25T09:44:44","date_gmt":"2022-05-25T13:44:44","guid":{"rendered":"https:\/\/www.extrafudge.com\/site\/?p=2993"},"modified":"2023-03-15T15:21:42","modified_gmt":"2023-03-15T19:21:42","slug":"exported-mint-transactions-manipulation-to-change-debit-numbers-to-minus","status":"publish","type":"post","link":"https:\/\/www.extrafudge.com\/site\/2022\/05\/exported-mint-transactions-manipulation-to-change-debit-numbers-to-minus\/","title":{"rendered":"Exported mint transactions manipulation to change debit numbers to minus."},"content":{"rendered":"<p>After exporting to excel\u00a0 select an empty column and put this in the first cell\u00a0 \u00a0Assuming D column has the amounts and E column has the debit\/credit<\/p>\n<p>=if(E1=&#8221;debit&#8221;,-D1,D1)<\/p>\n<p>Then just pull down the box to replicate this formula on the rest of the rows.<\/p>\n<p><strong>If this helped you please please <a title=\"Buy me coffee !\" href=\"http:\/\/goo.gl\/0cg2uu\" target=\"_blank\" rel=\"noopener\">consider buying me coffee!<\/a>\u00a0 Thanks in advance!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>After exporting to excel\u00a0 select an empty column and put this in the first cell\u00a0 \u00a0Assuming D column has the amounts and E column has the debit\/credit =if(E1=&#8221;debit&#8221;,-D1,D1)&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_sitemap_exclude":false,"_sitemap_priority":"","_sitemap_frequency":"","_seo_fixer_meta_description":"","_seo_fixer_focus_keyword":"","footnotes":""},"categories":[42],"tags":[319,126,314,318],"class_list":["post-2993","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-debit","tag-excel","tag-mint","tag-minus"],"_links":{"self":[{"href":"https:\/\/www.extrafudge.com\/site\/wp-json\/wp\/v2\/posts\/2993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.extrafudge.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extrafudge.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extrafudge.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extrafudge.com\/site\/wp-json\/wp\/v2\/comments?post=2993"}],"version-history":[{"count":0,"href":"https:\/\/www.extrafudge.com\/site\/wp-json\/wp\/v2\/posts\/2993\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.extrafudge.com\/site\/wp-json\/wp\/v2\/media?parent=2993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extrafudge.com\/site\/wp-json\/wp\/v2\/categories?post=2993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extrafudge.com\/site\/wp-json\/wp\/v2\/tags?post=2993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}