Home |
Search |
Today's Posts |
#1
|
|||
|
|||
allocating between positive and negative amounts
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. |
#2
|
|||
|
|||
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 "THosier" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
switching values from positive to negative | Excel Worksheet Functions | |||
How to vary color in an area chart between negative or positive d. | Charts and Charting in Excel | |||
Erf (the error function) for both negative and positive numbers | Excel Discussion (Misc queries) | |||
Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) |