View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy
 
Posts: n/a
Default 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.