Below is a possible solution to the problem – Challenge 47 – Generate Pentagonal Series
Put following formula and drag down –
=ROWS($1:1)*(3*ROWS($1:1)-1)/2
Below is a possible solution to the problem – Challenge 47 – Generate Pentagonal Series
Put following formula and drag down –
=ROWS($1:1)*(3*ROWS($1:1)-1)/2