If Function for BLANK cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
How do I return "leave cell blank" using IF logic. 3
Arrange to present in continuous format 4
Excel formula / IF function 5
Excel Add ^ to a row of cells containing letters 3
Adding Cells, Get Error. 2
Excel-only average cells if two cells in same row, meet two condit 5

Back
Top