Thread: if then else formual q

have a range of numbers in columns i through p. I have the usl in column g and the lsl in column h. i want to evaluate the range of numbers to see if they are greater than the spec. or less than the spec. if they are i want the word 'fail' to appear; otherwise, I want the word 'pass' to appear.

Can you help me with this formula

usl and lsl are upper spec limit and lower spec limit. ...i want to see if the range of numbers in columns i thru p are within spec

=IF(OR((I2:P2)<H2),((I2:P2)>G2)),$S$1,$R$1 this is the formula i used. columns i thru p are the raw data. column g = usl and h = lsl. column s1 = fail and column r 1 = pass. I get an error message.

So you have values in columns i through p. Do you want to evaluate whole rows or each cell in i through p individually? Where will "Pass" or "Fail" appear?

Try this:

=IF(OR(H2>(I2:P2),G2<(I2:P2)),$S$1,$R$1)

This is an array formula that must be committed using Ctrl+Shift+Enter.

So copy the above formula into the formula bar, and then press:
Ctrl+Shift+Enter

HTH,
Paul

thanks pclive! it works.