Using =(if(mod(row) function

[mmandym000k]

I'm building an Excel sheet that Adds 2 onto the previous cell every nth row as specified in cell $C$1. (It's for working out where to place increase stitches in a jumper sleeve!)

I cannot get the function to work for the first few rows; it excludes "Row 1" (actually row 5 on the spreadsheet) in the series.

The function I am using in "Row 2" is =IF(MOD(ROW(),$C$1)=0,C5+2,C5)

However, if I change it to make the calculation every 4 rows it doesn't work in the same way. Similarly if I change it to every 6 rows

I've tried all sorts of variations using =0 or =1. Or changing the cell reference for Row(). Can anybody help me please?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(MOD(ROWS(C$6:C6),$C$1)=0,C5+2,C5)

 

[mmandym000k]

Hi & welcome to MrExcel.
How about

=IF(MOD(ROWS(C$6:C6),$C$1)=0,C5+2,C5)

Thanks for coming back so quickly; this worked if I entered either 4, 5 or 6 in $C$1 as per the examples I gave, but it wouldn't work for other numbers such as 2, or 3.

 

[Fluff]

It works for me with other numbers

+Fluff 1.xlsm
	A	B	C	D	E	F
1			2	3	7	8
2
3
4
5			27	27	27	27
6			27	27	27	27
7			29	27	27	27
8			29	29	27	27
9			31	29	27	27
10			31	29	27	27
11			33	31	27	27
12			33	31	29	27
13			35	31	29	29
14			35	33	29	29
15			37	33	29	29
16			37	33	29	29
17			39	35	29	29
18			39	35	29	29
19			41	35	31	29
20			41	37	31	29
21			43	37	31	31
Main

Cell Formulas
Range	Formula
C6:F21	C6	=IF(MOD(ROWS(C$6:C6),C$1)=0,C5+2,C5)

 

[mmandym000k]

Yes it does - Thank you! I think I'd spent so long working on this yesterday, I'd gone stir crazy with it.
Thanks for your help!

 

[Fluff]

Glad it's sorted & thanks for the feedback.

 

[Joe4]

Note: When selecting a post to mark as the "solution", you want to mark the post that actually contains the solution, by the person who provided the solution.
Please do not mark your own post that acknowledges that someone else posted the solution.
You would only mark your own post if your answered your own question and posted that solution to the thread.
I have updated it on this thread.