Formulas: If(AND( , OR(NOT(COUNTIF not working correctly

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    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")),E44<=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.


    Cross posted on vbax http://www.vbaexpress.com/foru…TIF-now-working-correctly


    I have not gotten any answers from vba express yet.


    Thanks,


    Jeff

  • royUK

    Changed the title of the thread from “Formulas: If(AND( , OR(NOT(COUNTIF now working correctly” to “Formulas: If(AND( , OR(NOT(COUNTIF not working correctly”.