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

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