=IF(AND(A1="",B1<""),"x","")
--
Gary''s Student


"Andy" wrote:

I have two columns, one of which row by row, may have blank cells in and
other may have data.

I need to create a function in C1 to say IF A1 is NULL AND B1 is NOT NULL,
then return a character.

Probably some combination of If and AND statements, but can't get it to work.

Help greatly appreciated as ever.