for my part of it, change
(B2="",
to
(B2<"",

I think RagDyeR has given you the rest of it.

"Cassie" wrote:

OK- I guess I said that backwards. I only want the numbering if there is
data in cell b2. How does that change the formula? Would it be =IF(B2
isnotblank,2,"")
--
Cassie


"JLatham" wrote:

Close! But not quite there. Try
=IF(B2="",2,"")
you don't need the word "then" in there, the format for the IF() is
IF(test condition, true action, false action)


"Cassie" wrote:

How can I autopululate a row number in a cell A* ONLY if there is data is
entered in B*? I tried an =IF(b2= " ",then "2") in the cell I want the
number to appear and that did not work.
--
Cassie