Apply Excel formula to every nth cell
Solution 1:
Enter =H5 -(C5 * H8)
in cell I5
.
Leave cells I1:I4
blank.
Select cells I1:I5
and drag/fill down as far as you need.
Result:
Enter =H5 -(C5 * H8)
in cell I5
.
Leave cells I1:I4
blank.
Select cells I1:I5
and drag/fill down as far as you need.
Result: