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
|