I would like to use Airtable to do my accounting, but I need a formula that is way above my paygrade, maybe someone here can help?
I have a (single select) column 'deposit/withdrawals" and an amount column where all amounts are positive. I’d like to have the withdrawal amounts show as negative. So I made a third column where I’d like to say “if column 1 says withdrawal, then please give me column 2 amount as -amount, if it says deposit, then please give me column 2 as +amount”.
Maybe that’s not the right way to go (?) but in any case, I’d love some help if possible! Thank you!