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
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
how do I update my formula to ignore blanks or apply to cells with text?
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
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks