If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sources and Uses
Hope you can help. Looking to solve for value "X" which
makes the sum of "Sources" equal to the sum of "Uses", that is, how much do I need to break even. It's not as easy as sum(Uses) less sum(Sources) because odd or even iterations give different results. One further complication is that one of the Uses is dependent on the sum of the Sources (taxes on Sources). Excel give some really weird answers when you factor that in. Would appreciate any advice you can give. Thanks Sources 10 20 X __ 30 sum Sources Uses 40 50 __ 90 sum Uses |
#2
|
|||
|
|||
Sources and Uses
it is sum(uses)-sum(sources except x).
ToolsoptionsCalculation, check Iteration and the options there. -- Kind Regards, Niek Otten Microsoft MVP - Excel "BldrBldr" wrote in message ... Hope you can help. Looking to solve for value "X" which makes the sum of "Sources" equal to the sum of "Uses", that is, how much do I need to break even. It's not as easy as sum(Uses) less sum(Sources) because odd or even iterations give different results. One further complication is that one of the Uses is dependent on the sum of the Sources (taxes on Sources). Excel give some really weird answers when you factor that in. Would appreciate any advice you can give. Thanks Sources 10 20 X __ 30 sum Sources Uses 40 50 __ 90 sum Uses |
#3
|
|||
|
|||
Sources and Uses
It works. Thanks for your help!
-----Original Message----- it is sum(uses)-sum(sources except x). ToolsoptionsCalculation, check Iteration and the options there. -- Kind Regards, Niek Otten Microsoft MVP - Excel "BldrBldr" wrote in message ... Hope you can help. Looking to solve for value "X" which makes the sum of "Sources" equal to the sum of "Uses", that is, how much do I need to break even. It's not as easy as sum(Uses) less sum(Sources) because odd or even iterations give different results. One further complication is that one of the Uses is dependent on the sum of the Sources (taxes on Sources). Excel give some really weird answers when you factor that in. Would appreciate any advice you can give. Thanks Sources 10 20 X __ 30 sum Sources Uses 40 50 __ 90 sum Uses . |
Thread Tools | |
Display Modes | |
|
|