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

  • [xpost][/xpost]

    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.


    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…TIF-now-working-correctly

    I have not gotten any answers from vba express yet.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!