I'm looking for a formula to properly calculate the amount to allocate to
accounts, some with positive balances, some with negative. example, I need
to allocate a $500,000 increase to ten different accounts (based on
percentage of the total), with some accounts having a debit balance, and some
a credit balance. Would using absolute values work? Any ideas? Thanks.