# Place X in cell if criteria met`

1. ## 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

2. ## 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
>
>

3. ## 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
> >
> >

4. ## 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
> >
> >

5. ## Re: Place X in cell if criteria met`

Hi

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
>>>
>>>
>>>
>>>

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

#### 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