I can't find expressions in VBA

Abel_Collert

New Member
Joined
Mar 2, 2025
Messages
1
Office Version
  1. 365
  2. 2024
  3. 2021
  4. 2019
  5. 2016
  6. 2013
  7. 2011
  8. 2010
  9. 2007
  10. 2003 or older
  11. Prefer Not To Say
Platform
  1. Windows
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)
 

Attachments

  • photo_2025-03-03_00-30-38.jpg
    photo_2025-03-03_00-30-38.jpg
    77.6 KB · Views: 26
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?
 
Upvote 0

We've detected that you are using an adblocker.

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.
Go back
Back
Top