title: How to pass the "If" result to another cell
body: <p>I'm creating a business trip cost table with the following columns:
  <code>"A" = Status</code> ; <code>"B" = planned costs</code> (other columns doesn't matter now)
  Column "A" has drop down list with "planned, done, cancelled" values.
  Column "B" cells always has a number in it. (So in B column I can't write any function, because It will overwrite the price).</p>
  
  <p>What I want is a criteria or code when the status in column "A" is changed to "cancelled", then the planned cost next to it becomes 0 or clears the cell.</p>
  
  <p>I started to do this with a support sheet where I wrote a simple IF statement like this (in sheet2 random cell) <code>=if(A2="cancelled"; B2=0; "")</code>. But in this way it doesn't working. Simply gives a false result in to the random cell.</p>
  
  <p>Any help would be appreciated.</p>