Consulting

Results 1 to 7 of 7

Thread: Formulas: If(AND( , OR(NOT(COUNTIF now working correctly

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    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 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
  •