You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am trying to upload csv files for accounting and need credit and debit transactions in one column. can anyone help me with a formula? I Have never done this before
iMac 27″ 5K, macOS 13.6
Hi Belinda,
There are as many ways to do this as there are different .csv formats and layouts.
Please post a screen shot of part of your csv table. Include column headings. Delete or hide personal details.
Regards,
Ian.
Hi Belinda,
Thanks for the screen shot.
Formula in F2 (and fill down) is E2−D2
Sorry, I don't understand how the Balance is calculated.
Regards,
Ian.
how to create a column with debits and credits in one?
