Excel formula not working in VBA
I want to use the following excel formula in VBA
=IF(C3=0,"Nil Forecast",IF(E3=0,"Nil Sale",F3/C3))
Actually i am trying to assign the formula to a cell in excel using VBA. But,When i use text strings i.e "Nil Forecast" & "Nil Sale" in the formula the VBA does not understand.
And when i replace the text strings with a reference cell, it works.
Please give me solution for this.