Good day to all, for several weeks now I have not been able to overcome the task of solving this formula in vba basic exel, I hope for your knowledge and help (the values of X are in the range from 0 to 1)
What do you mean by "solve this formula"? What values do you have and where are they stored in Excel?
Also you are solving for x using x as a term on the other side, so this is going to be complicated. And because there are sum terms on the right it may require an iterative solution rather than an analytical one. I'm not strong enough in math to tell just by looking at this.
What does the C notation mean? The syntax looks similar to the sum (sigma) notation but I've never seen it before.
Can you give the context of the real-world problem you are trying to solve? Where did you get this formula?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.