?

Report
Question
Based on the values in Cells A51:A55, what formula can you copy and paste into Cells B51:B55 to return the values shown?AB51RedYes52RedYes53RedYes54BlueNo55RedYesa.  =IFNA(A51=”Red”,”Yes”,”No”)b. =SHOWIF(A51=”Red”,”Yes”,”No”)c. =COUNTIF(A51=”Red”,”Yes”,”No”)d. =SUMIF(A51=”Red”,”Yes”,”No”)e. =IF(A51=”Red”,”Yes”,”No”)

Please briefly explain why you feel this question should be reported .

Report
Cancel
solved 0
8 months 1 Answer 15 views Teacher