Unable to apply the grater than and lessthan function in multiblle cells

[VICKYSUBRAMANIAN]

Hi Mr.Excel,
My values are in J,K,L,M,N cells and result was in P"Cell, I need the formula for if all the cells are contain the values with 0.45 to 0.75 result to be show as GOOD and if one cell also contain the low value it must shown as "BAD",i am trying with my self more than two days but i cant, kindly help me.. please.

 

[Trebor76]

Hi Vicky,

Welcome to MrExcel!!

Try this in cell P3:

=IF(AND(MIN(J3:N3)>=0.45,MAX(J3:N3)<=0.75),"Good","Bad")

Regards,

Robert

 

[VICKYSUBRAMANIAN]

Hey Robert, thanks a lot man.. so greatful to you

 

[Trebor76]

You're welcome