need formula for extracting out-of-spec value

[saziz]

I have following cols.

Measured value| Design value| Upper Limit| Lower Limit

I want in the next col. the value, it is going out, both cases, being lower than design value or over the design value.
Please help me.

Thank you.

[Limor_OP]

Hi,
please upload a sample workbook to understand what you mean , and what are the results you are looking for.