Using IF argument for multiple criteria

F

ferde

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
 
F

ferde

Thank you for the reply but this formula will place a name in column A when
only one cell is empty. I only want an answer in b2 if all the cells in
the range C2:E2 are ALL empty . I'm sorry ... I probably wasnt clear.

Thank you again
 
Top