View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ferde ferde is offline
external usenet poster
 
Posts: 87
Default Using IF argument for multiple criteria

A B C D E
1 Incomplete Name Excluded Included Charted
2 Jill Cook
3 Pluto Ginnez yes
4 Peter Nutty yes
5 Jack Houston yes

Can anyone tell me how to correctly write the formula for the following
question? IF c2:E2 is empty than I need the name in B2 to appear in A2

Thank you in advance
Ferde