| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with multiple argument formula | Excel Worksheet Functions | |||
| return multiple records matching multiple criteria | Excel Worksheet Functions | |||
| How do I set up an argument which asks for multiple criteria | Excel Discussion (Misc queries) | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Linear Mode
