Excel apply a formula until the end of a column
<p>Here is my situation.</p>

<p>I am going to make a formula which will return me a Boolean value according to a value in other column. For example, IF
A1 = 0, B1 = FALSE
A2 = 1, B2 = FALSE</p>

<p>Here is the problem, I want this formula can apply when new data is being input. I solve it by pull the formula until B9999, but I don't like this. I want it B(?) will automatically find the value when A(?) is being input. </p>

<p>Thanks for your attention, please help me.</p>