Please help this formula convert to excell
X^1 + X^2 +...+ X ^ n - n > 20
where X and n is known value A1 and A2 for example.
the problem is I can't figure out how to make excel create additional missing numbers. because if i enter n = 20 then it will be 20 digits etc...
Please help.
Welcome to the forum, Jack.
=SUMPRODUCT(A1^ROW(INDIRECT("1:20"))) - 20
Please take a few minutes to read the forum rules, and then amend your thread title accordingly.
Entia non sunt multiplicanda sine necessitate
Array formula, enter with CTRL+SHIFT+ENTER
=SUM(POWER(2,ROW(1:20)))
Edit: 2 is corresponding to your X
1:20 is corresponding to your N
Last edited by Andy Pope; 02-11-2011 at 01:42 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks