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).

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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