Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-06-2015, 02:32 PM
tbesh tbesh is offline If IF/AND Criteria is Blank, Give me "Blank" Windows 7 64bit If IF/AND Criteria is Blank, Give me "Blank" Office 2010 64bit
Novice
If IF/AND Criteria is Blank, Give me "Blank"
 
Join Date: Sep 2015
Posts: 1
tbesh is on a distinguished road
Unhappy 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).
Reply With Quote
 

Tags
blank, false, if and



Similar Threads
Thread Thread Starter Forum Replies Last Post
If IF/AND Criteria is Blank, Give me &quot;Blank&quot; Weird "new/blank document" format in Word 2007 bjones Word 2 06-07-2014 06:45 AM
If IF/AND Criteria is Blank, Give me &quot;Blank&quot; Suppress comma in "city , stat zip" line when blank DHammer Mail Merge 1 05-30-2014 02:43 AM
If IF/AND Criteria is Blank, Give me &quot;Blank&quot; 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft