Hi,

I am trying to use a formula to count Yes or No but can't make it.
Condition like -

If cell A1 has any word then it will show Yes in cell B1, If cell A1 is blank then it will show "No".

Example:
A B
June Yes
No
Japan Yes
India Yes
No
India Yes.


I can work with only. This can show only Yes but other cells remain "Blank" insted of "No"

=If(A1="",A1,"Yes")

I need help regarding this.