You 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. =TRUE(B1<>"Sold Out")
c. =IF(B1="Sold Out", "TRUE", "FALSE")
d. =NOT(B1="Sold Out")
Answer: d. =NOT(B1="Sold Out")
If the answers is incorrect or not given, you can answer the above question in the comment box. If the answers is incorrect or not given, you can answer the above question in the comment box.