B Is there a formula to get x in Excel without using solver: 0.5^x+0.2^x+0.25^x=1

  • B
  • Thread starter Thread starter The Investor
  • Start date Start date
  • Tags Tags
    Excel Formula
AI Thread Summary
The equation 0.5^x + 0.2^x + 0.25^x = 1 lacks a neat formula for solving for x. There is no analytic solution, making it a non-standard problem. Iterative approaches are necessary, which can be implemented using Excel's solver, macros, or methods like Newton's method within Excel cells. Ultimately, Excel does not provide a straightforward formula for this equation. Therefore, alternative computational methods are required to find the solution.
The Investor
Messages
34
Reaction score
0
TL;DR Summary
Hi! I wanted to see if there is a formula to get x in excel without using solver: 0.5^x+0.2^x+0.25^x=1. Thanks!
0.5^x+0.2^x+0.25^x=1.
 
Mathematics news on Phys.org
I don't think there is a neat formula for x.
https://www.wolframalpha.com/input/?i=0.5^x+0.2^x+0.25^x=1

1602626567806.png
 
  • Like
Likes morrobay and berkeman
There is no analytic solution to it and it's not a standard problem, so you need some sort of iterative approach. You can do that with the solver, you can write a macro to do it, you can even do it in some Excel cells (e.g. using the Newton method), but Excel won't have a nice formula for it.
 
  • Like
Likes berkeman
OK, that's what I thought. Cheers guys.
 

Thread 'Non-orthogonal bases'

Suppose ,instead of the usual x,y coordinate system with an I basis vector along the x -axis and a corresponding j basis vector along the y-axis we instead have a different pair of basis vectors ,call them e and f along their respective axes. I have seen that this is an important subject in maths My question is what physical applications does such a model apply to? I am asking here because I have devoted quite a lot of time in the past to understanding convectors and the dual...
View full post »

Thread 'What Exactly is Dirac’s Delta Function? - Insight'

Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
View full post »

Similar threads

B How Do You Derive the Formula for sin(x-y)?
Replies
5
Views
2K
  • Poll Poll
MHB TikZ Challenge 1 - Geometrical Diagram - Votes
Replies
1
Views
2K
I Analytic Solution to ##x^{\alpha} +x =1##?
Replies
19
Views
1K
Spring constant formlula for Force and Work Done
Replies
12
Views
2K
B Need an on-line calculator for a simple calculation
Replies
12
Views
3K
MHB System of equations - Relative error
Replies
16
Views
4K
MHB Solving Trig Identity: Sin[1/2 sin^−1 (x)] = 1/2 X (sqr(1+x) –sqr(1-x))
Replies
2
Views
1K
I Is there any solution to the equation x^(0.5)+1=0?
Replies
15
Views
3K
Thermodynamics - Dryness fraction Equations
Replies
1
Views
634
MHB 5.t.11 find x for the imaginary factors
Replies
2
Views
1K

Hot Threads

Recent Insights

Back
Top