IFERROR statement with an If(and... formula
I need help. I can get the if/and statement to work, BUT if the cell is blank it gives one of the options.
=IFERROR(IF(AND([Bottom OP]1 >= [Spec - Low]1, [Bottom OP]1 <= [Spec - High]1)), "In Spec", "Out of Spec")), 0)
without the iferror statement it will say "Out of Spec" where I want it to say nothing.
Help Article Resources
Check out the Formula Handbook template!