allocating between positive and negative amounts

G

Guest

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.
 
G

Guest

Assumptions:
A1 = $500,000
A2 thru A11 contain the account balances
Formula in B2 =
=(($A2/SUM($A$2:$A$11))*$A$1)+$A2
copy this down to B11

HTH,
Gary Brown
Financial Consultant
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting positive amts from negative and positive from positive 3
summing only positive or negative values 2
subtract a positive from a negative 7
formula for finding out the negative numbers 3
Reallocate array cells value from positive to negative 0
Hide reords in a report 1
HELP! Need to sum columns where credit balances are shown as ###CR 20
HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN 5

Top