Sale!

(Solved) : Your Workbook Contains A List Of Artwork Column B Lists Sold Out If The Piece Is Sol 6084514

$ 12.00

Your workbook contains a list of artwork. Column B lists Sold Out if the piece is sold out, Available if it is still readily available, or Limited if only a few pieces are available. In the third column, you want to display TRUE if the art is not sold out. What function would produce the same…

SKU: 9f46256e5f41 Category:

Description

Your workbook contains a list of artwork. Column B lists Sold Out if the piece is sold out, Available if it is still readily available, or Limited if only a few pieces are available. In the third column, you want to display TRUE if the art is not sold out. What function would produce the same results as =OR(B1=”Available”,B1=”Limited”)?

 (a) =AND(B1=”Available”,B1=”Limited”)

 (b) =IF(B1=”Sold Out”,”TRUE”, “FALSE”)

 (c) =NOT(B1=”Sold Out”)

(d) =TRUE(B1″Sold Out”)

<... View full description