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.
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. 

closed as too localized by Mike Fitzpatrick, Indrek, Canadian Luke, Diogo, Synetech Oct 12 '12 at 1:32This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question. 





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.:


