IF/THEN when pointint cell contains an existing formula

[Roo007]

cell a1 ...1
cell a 2 ...=a1+1
cell a 3 ...=a2+1
cell a 4 ...=a3+1
cell a 5 ...=a4+1

in cell b1 ... I want the results of IF cell A5 equals 5 then return a 1, if not then +1 the number like above.

Im trying to loop 1-5 in each column based on the last cells info.

Can you assist?

 

[StephenCrump]

Is this what you mean?

B1: =MOD(ROWS(B$1:B1)-1,5)+1 (copy down)

 

[Joe4]

Cross-posted here: IF/THEN when pointing cell contains an existing formula

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Roo007]

Cross-posted here: IF/THEN when pointing cell contains an existing formula

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

What do you mean by "cross-posting"? I only posted once on this site.

 

[Roo007]

Is this what you mean?

B1: =MOD(ROWS(B$1:B1)-1,5)+1 (copy down)

Thank you very much! What if A5's number is a 3 or 4, Then B1, etc. would need to advance accordingly.???

If I'm not suppose to msg you, then I apologize in advance, & you probably shouldn't answer my question. I don't wan't to be in trouble.

 

[StephenCrump]

I don't wan't to be in trouble.

Your're not. Joe4 was just bringing to your attention the Forum rules. As Joe4 indicated, here's why cross-posting (i.e. to another forum) can be a problem. Excelguru Help Site - A message to forum cross posters.

We just ask that when you cross-post, you include the link(s) to those other Forums. That way people can check if you already have an answer, before they spend time on your problem.

I'm still not clear what you are asking. Can you please post a screenshot to illustrate, using the XL2BB add-in which you can download here: XL2BB - Excel Range to BBCode

This allows others to copy your workbook and formulae, e.g. click on the clipboard icon below, and you paste this screenshot directly into your spreadsheet. Much better than a description or a picture.

	A	B
1		1
2		2
3		3
4		4
5		5
6		1
7		2
8		3
9		4
10		5
11		1
12		2
13		3
14		4
15		5
Sheet1

Cell Formulas
Range	Formula
B1:B15	B1	=MOD(ROWS(B$1:B1)-1,5)+1

 

[Roo007]

Thank you for your help!