SOLVED: Based on the values in Cells A51:A55, what formula
https://www.numerade.com/ask/question/based-on-the-values-in-cells-a51a55-what-formula-can-you-copy-and-paste-into-cells-b51b55-to-return-the-values-shown-a-b-51-red-yes-52-red-yes-53-red-yes-54-blue-no-55-red-yes-ifnaa51redyesn-68173/
WebQuestion. Based on the values in Cells A51:A55, what formula can you copy and paste into Cells B51:B55 to return the values shown? A B 51 Red Yes 52 Red Yes 53 Red Yes 54 Blue No 55 Red Yes =IFNA (A51="Red","Yes","No") =SHOWIF (A51="Red","Yes","No") =COUNTIF (A51,"Red","Yes","No") =SUMIF (A51,"Red","Yes","No")
DA: 48 PA: 43 MOZ Rank: 5