title: What to key in for if time = 1, if na =0?
body: <p>I'm new in this world. As you can see in the picture, I key in function at B1 and I want B1 to return <code>1</code> if A1 data is <strong>time</strong>. But it kept of giving me <code>0</code>. At the same time, I want if there are no value or N/A, it must return <code>0</code>. What should I key in? I do understand that if using <code>=ifna(&quot;A&quot;,&quot;1&quot;,&quot;0&quot;)</code>, but that still does not return me anything for if there are any data.</p>
  <p><img src="https://i.stack.imgur.com/ZhVKy.png" alt="" /></p>