title: Excel conditional formatting that returns a value
body: <p>I am currently working on an excel project. I came across this specific issue where if cell A1=&quot; Achieved&quot; then cell A2 = &quot;1&quot; else cell A2=&quot; 0&quot;. My question is can it be done without using the If Else statement? I tried using the If Else statement but with formula I cannot get the sum total of the column.</p>
  <p><a href="https://i.stack.imgur.com/KuIox.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KuIox.jpg" alt="Excel value form" /></a></p>