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
|