P Pete_UK Apr 24, 2009 #3 It looks like your answer should be: 54325 With 5 in A1 and 25 in A2, put this formula in A3: =(INT(A2/10^ROW(A1))+1)*10^(ROW(A1)+1)+A2 and copy down. Hope this helps. Pete
It looks like your answer should be: 54325 With 5 in A1 and 25 in A2, put this formula in A3: =(INT(A2/10^ROW(A1))+1)*10^(ROW(A1)+1)+A2 and copy down. Hope this helps. Pete
T Toothsome Papa Apr 24, 2009 #4 I hope it took you guys longer than just a minute to come up with that answer...
D Dana DeLouis Apr 25, 2009 #5 Hi. Not sure what the rule is for n>10, but perhaps the equation can be reduced for n <= 10 Place in A1, and copy down to A10. =(10^ROW()*(9*ROW() - 1) + 325)/81 HTH Dana DeLouis = = = = =
Hi. Not sure what the rule is for n>10, but perhaps the equation can be reduced for n <= 10 Place in A1, and copy down to A10. =(10^ROW()*(9*ROW() - 1) + 325)/81 HTH Dana DeLouis = = = = =
