I could really make this work if I were trying to get an answer of ACCEPT or
REJECT based on a percentage of anything outside of 3.0 to 5.0 being
rejectable.

The problem that I am having is that I have to consider multiple ranges and
elements.

Take for example that I have a piece of alloy steel.

The specification of that particular alloy says it should have:
CHROME 08.00 - 10.00
MOLYBDENUM 00.09 - 01.10
MANGANESE 00.30 - 00.60

Im trying to create a preset form so that when we perform a chemical
analysis of the alloy, my inspectors can simply input the percentages they
find. Based on the formulas I have entered, the form will automatically tell
them whether or not their measurements are acceptable or rejectable.

If every element reading falls within its own preset guidelines, the end
result will indicate: ACCEPT.

But if any one reading for that particular element falls outside of the
ranges required, it will indicate: REJECT.

I understand this seems difficult. I should know, Ive been trying to figure
it out on my own for a little over a week, haha.

But nonetheless, THANK YOU very much

"CLR" wrote:

This can be done with IF formulas......

For example, this one will give you an "x" if any cell in the row is below
3, or if any cell in the row is above 5
=IF(MIN(A3:C3)<3,"x",IF(MAX(A3:C3)5,"x",""))

What result would you like to see if you had mixed conditions in one
row...ie, 2 4 6, or 4 4 6 or 2 4 4.........

Vaya con Dios
Chuck, CABGx3