Help Please For Formula Copy Skipping Cells?

Originally Posted by FDibbins

ROW(A1) is just a counter, it is not actually referencing anything...

ROW(A1)=1
ROW(A2)=2
etc
so...
1*27
2*27
etc

Thanks, i'll try it again and let you know. Should this ten replace my IF function?