- Case StudyHelp.com
- Sample Questions
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?
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?
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")
The correct Option is B=IF(A51="Red", "Yes","No")
Explanation:
To determine the correct formula for Cells B51:B55 based on the values in A51:A55, I need to know the values in A51:A55 and the corresponding results you want to see in B51:B5... More