I need a formula to compare values in row to make sure if these values are within a certain range and if not to tell me which value is out of range.

[moody3006]

I need a formula to compare values in row to make sure if these values are within a certain range and if not to tell me which value is out of range.

 

[shift-del]

Hi

=MEDIAN(A1,min_value,max_value)<>A1

 

[moody3006]

I need to check row of element number 1 if its values lie between the corresponding lower and upper limits and if there's one number out of limits I want its cycle number written in the abnormal column. Thx for ur help

Hi

=MEDIAN(A1,min_value,max_value)<>A1