Thank you all for your help. They all worked fine.
Thank you for such prompt replies.

Regards Colin
--
Q3PD


"Roger Govier" wrote:

Hi

=IF(SUM(A1:E1)=0,"Pass",
IF(OR(SUM(A1,C1)=2,MAX(B1,D1,E1)15%),"Reaudit",
"Follow Up"))

--
Regards
Roger Govier



"q3pd" wrote in message
...
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?
--
Q3PD