Matching conditions in cells

[arniebun]

I have look everywhere for this but can't find the answer. I have a row of cells with different numbers and i want to know if the all meet certain conditions. I want it to display healthily all the cells meet the conditions and fail if they don't. please help, would be appreciated.

clips	paper	boxes	folders	growth
-13385.75​	-10.8​	6.29%​	1.617%​	#VALUE!​	if all met	if not
when this is less than 0	when this is less than 0	more than 1.5%	more than 1 %	not more than 4% and not less than -4%	healthily	fail

 

[premjeet]

Check this if it can help you..

Put this formula in F2, If your data in range from A2:E2


=IF(AND((IF(A2<0,"Healthily","Fail"))=(IF(B2<0,"Healthily","Fail")),(IF(B2<0,"Healthily","Fail"))=(IF(C2>1.5%,"Healthily","Fail")),(IF(C2>1.5%,"Healthily","Fail"))=(IF(D2>1%,"Healthily","Fail")),(IF(D2>1%,"Healthily","Fail"))=(IF(AND(E2<=4%,E2>=-4%),"Healthily","Fail"))),"Healthily","Fail")

 

[arniebun]

Check this if it can help you..

Put this formula in F2, If your data in range from A2:E2


=IF(AND((IF(A2<0,"Healthily","Fail"))=(IF(B2<0,"Healthily","Fail")),(IF(B2<0,"Healthily","Fail"))=(IF(C2>1.5%,"Healthily","Fail")),(IF(C2>1.5%,"Healthily","Fail"))=(IF(D2>1%,"Healthily","Fail")),(IF(D2>1%,"Healthily","Fail"))=(IF(AND(E2<=4%,E2>=-4%),"Healthily","Fail"))),"Healthily","Fail")

Premjeet, you a legend, thanks a million

 

[Peter_SSs]

Does this much simpler one do the job too?

=IF(AND(A2<0,B2<0,C2>1.5%,D2>1%,E2<=4%,E2>=-4%),"healthily","fail")

 

[arniebun]

Does this much simpler one do the job too?

=IF(AND(A2<0,B2<0,C2>1.5%,D2>1%,E2<=4%,E2>=-4%),"healthily","fail")

Yes thank you so much

 

[tusharm]

Fwiw, the accepted solution will return the wrong result if all the conditions fail, in which case it will return 'healthy!'

13385.75​

10.8​

0.29%​

0.62%​

12%​

Healthily