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 formula is: B. =IF(A51=”Red”, “Yes”, “No”) Why? The IF function checks if a […]
