Given the following equation: 2^X - 2 = N
I'd like to solve for X. N is known.
What function could I use in Excel to do this?
Thanks in advance.
X = log(N+2)/log(2)
log
is an Excel function, the rest is more about solving an equation.
Put X in a cell and use the goal seek function, e.g.:
=2^A1-2