One way:

=IF(COUNTIF(A1:E1,0)=5, "Pass", IF(OR(A12, B115%, C12, D115%,
E115%), "Reaudit", "Follow-up")



In article ,
q3pd wrote:

In 'column a' I have cells with numbers ranging from 0 to 10.
In 'column b' I have cells with values ranging from 0% to 55%.
In 'column c' I have cells with numbers ranging from 0 to 10.
In 'column d' I have cells with values ranging from 0% to 34%.
In 'column e' I have cells with values ranging from 0% to 76%.
I require a function that returns 'Reaudit' when either 'column b', 'column
d' or 'column e' cells are greater than 15%: or if 'column a' or 'column c'
are greater than 2. If none of these are True it should return 'Follow-up'.
If all five columns were 0, it should return 'Pass'.

Please can any one help?