If Function for BLANK cells

[Andy]

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.

 

[Gary''s Student]

=IF(AND(A1="",B1<>""),"x","")

 

[Roger Govier]

Hi Andy

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

 

[Andy]

Spot on. Cheers everyone!

Hi Andy

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