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”)?
(b) =IF(B1=”Sold Out”,”TRUE”, “FALSE”)
(c) =NOT(B1=”Sold Out”)
(d) =TRUE(B1″Sold Out”)<... View full description