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")?
(b) =IF(B1="Sold Out","TRUE", "FALSE")
(c) =NOT(B1="Sold Out")
(d) =TRUE(B1"Sold Out")