If you mean that when data is entered into column a you want the column b to
have data that is the same as all data in column b then =if(a1<"","constant
info",""). This assumes that there is nothing in column a if there are
zeros, change the ""s to 0 in the formula.


"Roy" wrote:

I have info that goes into a cell based on info in the cell next to it and
that info is always the same. How do I get a cell to fill in automatically
based on information entered in another cell?
--
Roy