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 appreciated!!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!