If IF/AND Criteria is Blank, Give me "Blank"

tbesh · #1 09-06-2015, 02:32 PM

I have a workbook where people regularly populate if they have done a task for that week or not. I'm building a "compliance" sheet that will capture the overall % of completed tasks.

The trouble is getting the blank cells to produce the word "Blank". I DO NOT want the number zero produced for blank cells, as this will throw the conditional formatting off.

For example:

{=IF(AND($G$2:$G$93="*Annually*",$M$2:$M$93=""),"B lank",[COUNTIFS funtion])}

Where the frequency is "Annually" AND the completion status is "" (blank), give me "BLANK", otherwise give me the results of this COUNTIF function:

=(COUNTIFS($G$2:$G$93,"*Annually*",$M$2:$M$93,"*YE S*")/COUNTIFS($G$2:$G$93,"*Annually*",$M$2:$M$93,"<>N/A"))

The result I get from the IF/AND funtion is "FALSE" (even if the combination is true).

Pecoflyer · #2 09-07-2015, 09:43 AM

Hi and welcome
eventually post a sample sheet showing what you have and desired results?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Weird "new/blank document" format in Word 2007	bjones	Word	2	06-07-2014 06:45 AM
Suppress comma in "city , stat zip" line when blank	DHammer	Mail Merge	1	05-30-2014 02:43 AM
Word is displaying my "compatible" docs as blank!	RobDuBois	Word	3	01-20-2013 04:40 PM
"Inserting" 11x17 blank sheet into report	mcjohn	Word	2	01-06-2010 09:14 AM
"Intentionally left in Blank" Pages	Manolo	Word	2	04-30-2009 04:20 AM