+ Reply to Thread
Results 1 to 5 of 5

Place X in cell if criteria met`

  1. #1
    jhicsupt
    Guest

    Place X in cell if criteria met`

    Is there a formula to do this?

    If cell B2 = pencils
    Put an "X" in cell B7

    If cell B2 = pens
    Put an "X" in cell B8

    If cell B2 = erasers
    Put an "X" in cell B9

    Thanks in advance


  2. #2
    bj
    Guest

    RE: Place X in cell if criteria met`

    in cells B7 put
    =if(B2="pencils","x","")
    in Cell B8 put
    =if(B2="pens","x","")
    In cell B9 put
    =if(B2="erasers","x","")

    "jhicsupt" wrote:

    > Is there a formula to do this?
    >
    > If cell B2 = pencils
    > Put an "X" in cell B7
    >
    > If cell B2 = pens
    > Put an "X" in cell B8
    >
    > If cell B2 = erasers
    > Put an "X" in cell B9
    >
    > Thanks in advance
    >


  3. #3
    jhicsupt
    Guest

    RE: Place X in cell if criteria met`

    Thanks -- worked like a charm!

    "bj" wrote:

    > in cells B7 put
    > =if(B2="pencils","x","")
    > in Cell B8 put
    > =if(B2="pens","x","")
    > In cell B9 put
    > =if(B2="erasers","x","")
    >
    > "jhicsupt" wrote:
    >
    > > Is there a formula to do this?
    > >
    > > If cell B2 = pencils
    > > Put an "X" in cell B7
    > >
    > > If cell B2 = pens
    > > Put an "X" in cell B8
    > >
    > > If cell B2 = erasers
    > > Put an "X" in cell B9
    > >
    > > Thanks in advance
    > >


  4. #4
    jhicsupt
    Guest

    RE: Place X in cell if criteria met`

    I need to add another criteria to this.

    If B2 = "Pencils" or "pads" or "staplers"
    In Cell B8 put an "X"

    Can you help me with this formula?

    Thanks so much!

    "bj" wrote:

    > in cells B7 put
    > =if(B2="pencils","x","")
    > in Cell B8 put
    > =if(B2="pens","x","")
    > In cell B9 put
    > =if(B2="erasers","x","")
    >
    > "jhicsupt" wrote:
    >
    > > Is there a formula to do this?
    > >
    > > If cell B2 = pencils
    > > Put an "X" in cell B7
    > >
    > > If cell B2 = pens
    > > Put an "X" in cell B8
    > >
    > > If cell B2 = erasers
    > > Put an "X" in cell B9
    > >
    > > Thanks in advance
    > >


  5. #5
    Roger Govier
    Guest

    Re: Place X in cell if criteria met`

    Hi
    =IF(OR(B2="Pencils",B2="pads",B2="staplers"),"X","")

    Regards

    Roger Govier



    jhicsupt wrote:

    >I need to add another criteria to this.
    >
    >If B2 = "Pencils" or "pads" or "staplers"
    > In Cell B8 put an "X"
    >
    >Can you help me with this formula?
    >
    >Thanks so much!
    >
    >"bj" wrote:
    >
    >
    >
    >>in cells B7 put
    >>=if(B2="pencils","x","")
    >>in Cell B8 put
    >>=if(B2="pens","x","")
    >>In cell B9 put
    >>=if(B2="erasers","x","")
    >>
    >>"jhicsupt" wrote:
    >>
    >>
    >>
    >>>Is there a formula to do this?
    >>>
    >>>If cell B2 = pencils
    >>> Put an "X" in cell B7
    >>>
    >>>If cell B2 = pens
    >>> Put an "X" in cell B8
    >>>
    >>>If cell B2 = erasers
    >>> Put an "X" in cell B9
    >>>
    >>>Thanks in advance
    >>>
    >>>
    >>>


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1