Formula Fill to Begin at the False Statement

[nomi1432]

Hello All,I am trying to solve the following problem. in Cell D1 I enter this =if($A1=0,B1,B100) When I will fill the Formula down it changes to b2,B101 & b3,c102 ... What I am trying to accomplish is the false fill down to begin when it encounters the first fall situation. Assume cell A5 is the first time it finds a 0, I want the formula to if($A5=0,B5,B100). Is that at all possible?

 

[Joe4]

Welcome to the Board!

The key is understanding how Absolute, Relative, and Mixed range references work.
If you want to lock in row 100 for the B100 reference, change it to this:

[COLOR=#333333]=if($A1=0,B1,B$100) [/COLOR]

See here for more details and explanations:
http://www.cpearson.com/excel/relative.aspx

 

[nomi1432]

I tried that it did not work, what I am trying do is have the fill counter begin when it encounters the first false scenario. for egIf(a1=0,1,100) when I fill downwards the formula will be If(a2=0,2,101) so on and so forth. What I am trying to accomplish is the fill down to begin when it hits the first false scenario. If(True,1,100)If(True,2,100)If(True,3,100)If(False,4,101)If(False,4,102)I hope this explains my predicament.Thank you in advance

 

[Joe4]

I am not sure I understand what you are trying to do or why.
Perhaps walking us through an actual example may make it more clear.

There are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html. Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.