| 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) | |||
Linear Mode
