Hi, I've been trying to write a formula to calculate the number of rows when new rows are inserted at a give interval,
so in this case I have , keeping it simple, 13 rows, and I want to insert 3 rows at every 2nd row,
so ( ( 13 /2 ) * 3 ) + 13 , but I don't want rows added to then end; the best I've come up with so far is this, but are there better ways ?
Richard.
so in this case I have , keeping it simple, 13 rows, and I want to insert 3 rows at every 2nd row,
so ( ( 13 /2 ) * 3 ) + 13 , but I don't want rows added to then end; the best I've come up with so far is this, but are there better ways ?
Excel Formula:
=( IF( 13/2 = QUOTIENT(13,2) , ( (QUOTIENT(13,2)-1)* 3) + 13 , (QUOTIENT(13,3)*3) + 13 )) -3,
Richard.