Based on the values in Cells A51:A55, what formula can you copy and paste into Cells B51:B55 to return the values shown?
ReportQuestion
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 .
solved
0
8 months
1 Answer
15 views
Teacher