I am trying to obtain a Pass or Fail output in a single column based on two cells in two adjacent columns. This is numerical data. The data in each cell is a single value. Column A is the Pass/Fail output. Column B and C are values 1 and 2.

The value in column B must be within a certain tolerance limit. The value in column C must be within a certain tolerance limit. If either one (B or C) or both is not within tolerance, then the result is Fail. If both are within tolerance, then the result is Pass.

The value in column B must be within a certain tolerance limit. The value in column C must be within a certain tolerance limit. If either one (B or C) or both is not within tolerance, then the result is Fail. If both are within tolerance, then the result is Pass.