If Function for BLANK cells
 

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.

If Function for BLANK cells
 

=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.

If Function for BLANK cells
 

Hi Andy

=IF(AND(A1="",B1<""),"whatever_you_want","")

--
Regards

Roger Govier


"Andy" wrote in message
...
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.

If Function for BLANK cells
 

Spot on. Cheers everyone!

"Roger Govier" wrote:

Hi Andy

=IF(AND(A1="",B1<""),"whatever_you_want","")

--
Regards

Roger Govier


"Andy" wrote in message
...
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.