Based on the values in Cell A51: A55, what formula can you copy and paste in to Cells B51: B55 to return the values shown?
Answer:
A. =COUNTIF(A51="Red", "Yes","No")B. =IF(A51="Red", "Yes","No") C. =SUMIF(A51="Red", "Yes","No") D. =SHOWIF(A51="Red", "Yes","No")E. =IFNA(A51="Red","Yes","No")Correct Option is B=IF(A51="Red","Yes","No")
ExplantationThe following formula can be copied and pasted into Cells B51:B55 to
View or Download Samples