#1
|
|||
|
|||
If IF/AND Criteria is Blank, Give me "Blank"
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). |
#2
|
||||
|
||||
Hi and welcome
eventually post a sample sheet showing what you have and desired results?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
blank, false, if and |
|
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 |