Forum Discussion
How to create a rule to create a value based on content of 2 cells
Edit: Thanks to the forum. Now resolved. Hi. Assistance please. I suspect this is pretty simple but it has defeated me! I want to write a rule that generates a value in one cell based on the co...
=IF(COUNTIF(A1:B1,"Yes")=2,"Yes","No")
Many thanks. That has helped - think I've got it sorted.