Your workbook contains a list of artwork. Column B lists Sold Out if the piece is sold out,…


Your workbook contains a roll of artwork. Post B rolls Sold Out if the duty is sold out, Adapted if it is quiescent early adapted, or Limited if singly a few dutys are adapted. In the third post, you neglect to display TRUE if the art is not sold out. What capacity would amount 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")