Formulas: If(AND( , OR(NOT(COUNTIF now working correctly
I'm trying to get this formula to work correctly, not sue what I'm missing? Perhaps a fresh set of eyes will help.
Here is the formula commented out, have also attached a spreadsheet.
'=IF(AND(C44<=2,OR(NOT(COUNTIF(D44:49,">0.9")),NOT(COUNTIF(D44:49,"<2")),E4 4<=2,OR(NOT(COUNTIF(F44:F49,">0.9")),NOT(COUNTIF(F44:F49,"<2")),G44>=2,H44> =4.5))),"Pass","Fail")
The formula seems correct but if a value in one of the ranges is out of the bounds set the formula is incorrect. Note the formula looks like it picked up a space in this context.
Thanks,
Jeff
Attached Files
Last edited by jrdnoland; 06-01-2020 at 04:18 AM .
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules