Nested IF Help

F

FrankTimJr

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
 
F

Fred Smith

Try this:

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

Regards
Fred
 
F

FrankTimJr

Thank you sir! Works perfectly!

Fred Smith said:
Try this:

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

Regards
Fred



.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF statement 3
Forcing User inputs 1
Excel 2007 storing the high and low 3
Multiple if condition formula required 4
Formula for If "" AND "" are true... 3
Different cells that need to sum in one 4
Basic IF/AND and Nested IF/AND Statements? 2
Simple Average ? 3

Top