If Statement, ignore blanks

**shanikakbrown** · 10-12-2014, 01:01 PM

I have a if statment that is working:

=IF('Tab2'!G12<>"Fully Meets Expectation","DOES NOT MEET","DOES MEET")

however I need this formula to only be applied to cells with data within the cell or ignore blank cells. Someone please help.

Thanks

**shanikakbrown** · 10-12-2014, 01:05 PM

how do I update my formula to ignore blanks or apply to cells with text?

**canapone** · 10-12-2014, 01:07 PM

Hi,

a possible formula could be:

=IF(AND('Tab2'!G12<>"",'Tab2'!G12<>"Fully Meets Expectation"),"DOES NOT MEET","DOES MEET")

Hope it's a little help

**shanikakbrown** · 10-12-2014, 05:34 PM

IT WORKED!!! Thank you.

Originally Posted by shanikakbrown

I have a if statment that is working:

=IF('Tab2'!G12<>"Fully Meets Expectation","DOES NOT MEET","DOES MEET")

however I need this formula to only be applied to cells with data within the cell or ignore blank cells. Someone please help.

Thanks

Originally Posted by canapone

Hi,

a possible formula could be:

=IF(AND('Tab2'!G12<>"",'Tab2'!G12<>"Fully Meets Expectation"),"DOES NOT MEET","DOES MEET")

Hope it's a little help