# Contains Help

This is a discussion on Contains Help within the Excel Questions forums, part of the Question Forums category; here is the logic I am shooting for If C1 contains "Pilot" then CountA(A9:A200)*6,if C1 contains "Bic" then CountA(A9:A200)*7 Does ...

1. here is the logic I am shooting for

If C1 contains "Pilot" then CountA(A9:A200)*6,if C1 contains "Bic" then CountA(A9:A200)*7

Does this work?

2. On 2002-12-17 13:27, SCSA25 wrote:
here is the logic I am shooting for

If C1 contains "Pilot" then CountA(A9:A200)*6,if C1 contains "Bic" then CountA(A9:A200)*7

Does this work?
Does this work?

=if(c1="pilot",counta(a9:a200)*6,if(c1="bic",counta(a9:a200)*7,""))

3. What if Pilot is not the only text in the cell?

4. is it the first part?

just_jon

5. Yes it is

Generic Example

Cell A Cell B
1Division Mechanical Pencil
2Product Name Pilot 2300 Pencil
3Product # DA12345

If B2 has "Pilot" in it then *7 if it has "Bic" *6

6. On 2002-12-17 15:06, SCSA25 wrote:
Yes it is

Generic Example

Cell A Cell B
1Division Mechanical Pencil
2Product Name Pilot 2300 Pencil
3Product # DA12345

try a nexted if

=if(left(A1,5)="pilot",counta(A9:a200)*6,if(left(a1,3)="bic",counta(a9:a200)*7,""))

just_jon

[ This Message was edited by: just_jon on 2002-12-17 15:27 ]

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•