title: excel VBA using the "if function" in vba excel only show text in the worksheet
body: <p>first time asking here.</p>
  
  <p>i'm trying to make work the next code in vba:</p>
  
  <p><code>ActiveWorkbook.Sheets("COMP 1").Range("M916").formula= "+IF(AG$19="""";"""";1)"</code></p>
  
  <p>The issue is that if a put just the <strong>"+"</strong> in the code, in the work sheet just apear the text like this:</p>
  
  <p>And as you can see in the red circle, the option to show formulas is off, and int the green circles you can see that other formulas are working and showing the result:
  <img src="https://i.stack.imgur.com/Yd73h.png" alt=""> </p>
  
  <p>But if i try to put <strong>"=+"</strong> or <strong>"="</strong> in the code the error 1004 pops out.</p>
  
  <p>Btw sorry for my english, as is not my native lenguage</p>