Hello again everyone! I'm trying to create a formula that will scan a row of cells (A2:S2) and give a "Pass"/"Fail" condition if each cell is between two numbers on another tab. It also needs to ignore error (#N/A) cells and only count the cells with numbers in them.

So basically something like this...only working instead of doing nothing:

IF(AND(A2:S2<=Tol!B4,A2:S2>=Tol!C4),"Pass","Fail"))