If statement on blank cell

**Sam Capricci** · 03-20-2015, 09:19 PM

If you click on the cell and hit delete does that change the answer?

**peterrc** · 03-21-2015, 04:33 AM

Hi Ammartino44,
Remove the space between the " ", so it looks like this "".
Click the fx on the left of the formula and try both options.
" " gives the wrong answer
"" gives the right answer.
Regards
peterrc

If statement on blank cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: If statement on blank cell

Re: If statement on blank cell

Thread Information

Users Browsing this Thread

Similar Threads

if(or statement to return blank cell

IF Statement to leave cell blank if multiple cells are all blank

[SOLVED] If statement that copies text from a separate worksheet, or if blank, leaves cell blank.

If statement to return nothing if cell is blank

[SOLVED] keep cell blank when false in IF statement

Bookmarks

Bookmarks

Posting Permissions