Hi everyone. Thanks in advance for the help. I'm trying to teach myself some simple VBA commands and have a question. I'm sure its easy fo all of you with even a slight bit of knowledge. I want to insert a formula in a cell if another cell contains Y. If it doesn't contain a Y then I want the cell to be blank. Below is what I have. I can do it if I jusst want to add the cells together but cannot get it to work if I have a condition in another cell.
Sub formula_Example()
Range("B3").Formula = "=if(a1,"Y",b1+b2," ")"
End Sub
Sub formula_Example()
Range("B3").Formula = "=if(a1,"Y",b1+b2," ")"
End Sub