Countblank and If statements

[Geesman]

=IF(ISBLANK(Q22),"FAIL",COUNTif(C27:Q27)"=>"&$Q$22),IF(COUNTIF(C27:Q27,">"&$O$18),"FAIL","PASS")

I think I got myself twisted up here. The idea is to replace one of the Pass/Fail columns on the right with a code that leaves the portion IF(COUNTIF(C27:Q27, ">"&$O$18), "FAIL", "PASS") intact while adding an additional statement that if the required number of cycles has not been met, then the test fails.

I'd like the make the required cycles mandatory by failing the test if not filled, and I'd like to see if the number of cells filled in does not meet the required cycles, then it fails. THEN, if those conditions are met, we go to the statement above to score the test.

 

[Fluff]

Hi & welcome to MrExcel.
How about
=IF(OR(Q22="",COUNTA(C27:Q27)<$Q$22),"FAIL",IF(COUNTIF(C27:Q27,">"&$O$18),"FAIL","PASS"))

 

[Geesman]

Good morning,

Thank you for the tip. I tried that and a couple variations and I'm just getting a fail regardless of whether it fulfills or not.

This is the variation I'm working on now.

=IF(OR(Q22<>"",COUNTBLANK(C27:Q27)>$Q$22),"FAIL",IF(COUNTIF(C27:Q27,">"&$O$18),"FAIL","PASS"))

I'm going to share a link from Google Drive. The formula in Column T is the main that I'm working on which has this code, the one in Column U is just testing a the countblank formula.

https://docs.google.com/spreadsheets/d/1CNEfynkAS7i9CQDhcjZ8RXA7IGkchxQUYhob7-BpRNo/edit?usp=sharing

 

[Fluff]

That file is locked, you need to mark it for sharing & then post the link you are given.

 

[Geesman]

Thanks. >.<

Try now.

https://docs.google.com/spreadsheets/d/1CNEfynkAS7i9CQDhcjZ8RXA7IGkchxQUYhob7-BpRNo/edit?usp=sharing

 

[Fluff]

That is the same link as before & it's still asking me to sign in.

 

[Geesman]

And I just realized that one might not work because I have that drive locked.

I moved the file to a drive that can be accessed.

https://docs.google.com/spreadsheets/d/1MhLr60EMdpitL0LcowAWjuISZVx53CeHJtVlf6COOio/edit?usp=sharing

 

[Geesman]

Replied to myself instead of you, so I don't know if you saw the last come through, but I only set that last one to view.

I had the file in a locked drive. I've moved it to an accessible drive and allowed edit.

https://docs.google.com/spreadsheets/d/1MhLr60EMdpitL0LcowAWjuISZVx53CeHJtVlf6COOio/edit?usp=sharing

 

[Fluff]

Ok, the formula I supplied in post#2 works, BUT both Q22 & O18 are text values not numbers. You need to change them.

 

[Geesman]

Just test that and it works perfectly.

Thank you!