Formula to find out if "Out of Spec" or "Within Spec"

[Sashi Jaisingh]

Hi

Please refer to the spreadsheet I have attached.

In Row 4 I have the minimum specs for my data.

In Row 5 I have the maximum specs for my data.

In Row 6 I have the actual results for my data.

In Row 7 I want to be able to classify whether the actual results are "Out of Spec" or "Within Spec" based on the above minimum/maximum specs.

Any help will be greatly appreciated?

[Pepe Le Mokko]

Try =IF (And($D6>$D4,$D6<$D5),"Within","Out")

[Mrrrr]

If they are equal to min or max I'm assuming they are within spec.

Then it's this in D7:
=IF(AND(D6>=D4;D6<=D5);"Within";"Out")

Drag right.

[shg]

Or ...

=IF(MEDIAN(D4, D5, D6) = D6, "Within", "Out")