Results 1 to 6 of 6

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. #1
    Board Regular
    Join Date
    Jun 2002
    Posts
    147

    Default

    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. #2
    Board Regular
    Join Date
    May 2002
    Posts
    890

    Default

    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. #3
    Board Regular
    Join Date
    Jun 2002
    Posts
    147

    Default

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

  4. #4
    Legend just_jon's Avatar
    Join Date
    Sep 2002
    Location
    Alabama/State of Disarray
    Posts
    10,473

    Default

    is it the first part?

    just_jon

  5. #5
    Board Regular
    Join Date
    Jun 2002
    Posts
    147

    Default

    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. #6
    Legend just_jon's Avatar
    Join Date
    Sep 2002
    Location
    Alabama/State of Disarray
    Posts
    10,473

    Default

    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 ]

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com