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

Using IF argument for multiple criteria
 

One way:

A2: =IF(COUNTA(C2:E2)<3,B2,"")

In article ,
ferde wrote:

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

Using IF argument for multiple criteria
 

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

"JE McGimpsey" wrote:

One way:

A2: =IF(COUNTA(C2:E2)<3,B2,"")

In article ,
ferde wrote:

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

Using IF argument for multiple criteria
 

Change 3 to 1

In article ,
ferde wrote:

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.

Using IF argument for multiple criteria
 

Works GREAT....thank you for your help

"JE McGimpsey" wrote:

Change 3 to 1

In article ,
ferde wrote:

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.