I need some help defining a Nested IF Statement.

I need to check for the following conditions:

If A1="Yes", then B1, C1, D1, E1 must contain an entry (All 4 cells). If
TRUE, then enter "Compliant", otherwise enter "Non Compliant". I need the
statement to evaluate each of B1, C1, D1, E1 individually. If B1 has an
entry and C1 does not, then "Non Compliant".

Is this a clear enough description for some help?

Thanks in advance.
Frank

Try this:

=if(a1="Yes",if(counta(b1:e1)=4,"Compliant","Non Compliant"),"A1 not Yes")

Regards
Fred

"FrankTimJr" wrote in message
...
I need some help defining a Nested IF Statement.

I need to check for the following conditions:

If A1="Yes", then B1, C1, D1, E1 must contain an entry (All 4 cells). If
TRUE, then enter "Compliant", otherwise enter "Non Compliant". I need the
statement to evaluate each of B1, C1, D1, E1 individually. If B1 has an
entry and C1 does not, then "Non Compliant".

Is this a clear enough description for some help?

Thanks in advance.
Frank

Thank you sir! Works perfectly!

"Fred Smith" wrote:

Try this:

=if(a1="Yes",if(counta(b1:e1)=4,"Compliant","Non Compliant"),"A1 not Yes")

Regards
Fred

"FrankTimJr" wrote in message
...
I need some help defining a Nested IF Statement.

I need to check for the following conditions:

If A1="Yes", then B1, C1, D1, E1 must contain an entry (All 4 cells). If
TRUE, then enter "Compliant", otherwise enter "Non Compliant". I need the
statement to evaluate each of B1, C1, D1, E1 individually. If B1 has an
entry and C1 does not, then "Non Compliant".

Is this a clear enough description for some help?

Thanks in advance.
Frank


.

Glad to help. Thanks for the feedback.

Regards,
Fred

"FrankTimJr" wrote in message
...
Thank you sir! Works perfectly!

"Fred Smith" wrote:

Try this:

=if(a1="Yes",if(counta(b1:e1)=4,"Compliant","Non Compliant"),"A1 not
Yes")

Regards
Fred

"FrankTimJr" wrote in message
...
I need some help defining a Nested IF Statement.

I need to check for the following conditions:

If A1="Yes", then B1, C1, D1, E1 must contain an entry (All 4 cells).
If
TRUE, then enter "Compliant", otherwise enter "Non Compliant". I need
the
statement to evaluate each of B1, C1, D1, E1 individually. If B1 has
an
entry and C1 does not, then "Non Compliant".

Is this a clear enough description for some help?

Thanks in advance.
Frank


.