Multiple nested If statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
One way:

=IF(COUNTIF(A1:E1,0)=5, "Pass", IF(OR(A1>2, B1>15%, C1>2, D1>15%,
E1>15%), "Reaudit", "Follow-up")
 
One way:
=IF(OR(B2>15%,D2>15%,E2>15%,A2>2,C2>2),"Reaudit",IF(AND(A2=0,B2=0,C2=0,D2=0,E2=0),"Pass","Follow-
up"))

Another Way:
=IF(OR(B2>15%,D2>15%,E2>15%,A2>2,C2>2),"Reaudit",IF(SUM(A2:E2)=0,"Pass","Follow-
up"))
 
Hi

=IF(SUM(A1:E1)=0,"Pass",
IF(OR(SUM(A1,C1)=2,MAX(B1,D1,E1)>15%),"Reaudit",
"Follow Up"))
 
Thank you all for your help. They all worked fine.
Thank you for such prompt replies.

Regards Colin
 
Back
Top