IF Function

[Helen28]

Hi there,

I posted the following the other day:

((Data:
5 collums of data (A,B,C,D,E) and 33 participants.
If Function needed for:
define person as 'risk' if either '3 out of 4 values (A,B,C,D) are smaller than 10' OR if '2 out of 4 values (A,B,C,D) are smaller than 10 AND E< 15'. Otherwise no risk.))

Special-K kindly provided a formula that solved the problem. Now my work has turned round with another set of conditions :

In addition to the risk category, I now need another two categories.
1. risk (see above)
2. medium (if neither risk nor no risk)
3. no risk (3 out 4 values of A,B,C,D greater than 40% and E>40)

I have spent ages trying to amend the function I already have for the risk category only, but all I get is a lot of different error messages!
This is one of many attempts:
=IF(OR(COUNTIF(A3:D3,"<10%")=3,AND(COUNTIF(A3:D3,"<10%")=2,E3<15)),"Risk",IF(COUNTIF(A3:D3,">40%")>3),AND(F3>40),"no risk","medium")


Sorry for posting this again! Any help would be greatly apprreciated!
Helen

[Special-K]

Try

in G3
=IF(OR(COUNTIF(A3:D3,"<10%")=3,AND(COUNTIF(A3:D3,"<10%")=2,E3<15)),"","No ")&"Risk"
and copy down the column

[Helen28]

Special-K,

it works! Thank you so much for your help!

Best wisches,
Helen