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

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

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

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

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