Nested IF Help

  • Thread starter Thread starter FrankTimJr
  • Start date Start date
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
 
Try this:

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

Regards
Fred
 
Back
Top