Thread: Nested IF Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FrankTimJr FrankTimJr is offline
external usenet poster
 
Posts: 16
Default Nested IF Help

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