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

  • #1

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.
 

Answers and Replies

  • #3
34,951
11,135
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
  • #4
OK, that's what I thought. Cheers guys.
 

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

Replies
15
Views
1K
Replies
4
Views
1K
Replies
5
Views
1K
Replies
5
Views
2K
Replies
5
Views
2K
  • Last Post
Replies
6
Views
3K
Replies
5
Views
2K
Replies
1
Views
412
  • Last Post
Replies
2
Views
2K
Replies
32
Views
33K
Top