Multiple nested If statements
 

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

Multiple nested If statements
 

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?

Multiple nested If statements
 

One way:
=IF(OR(B215%,D215%,E215%,A22,C22),"Reaudit",I F(AND(A2=0,B2=0,C2=0,D2=0,E2=0),"Pass","Follow-
up"))

Another Way:
=IF(OR(B215%,D215%,E215%,A22,C22),"Reaudit",I F(SUM(A2:E2)=0,"Pass","Follow-
up"))

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?
--
Q3PD

Multiple nested If statements
 

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

Multiple nested If statements
 

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