Using IF argument for multiple criteria

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

named ranges in multiple criteria formula 4
using if for multiple criteria 22
Multiple Ifs, can't use vlookup 3
Consolidation if a least one criteria is met 4
Using VBA To Sort Multiple Criteria 1
Using the IF fuction for multiple cells 2
COUNTIF with multiple criteria doesn't work 5
Copy multiple values into a single cell 4

Top