Hi Friends,
This is the formula I have in excel cell: =IF('P1'!S6:Z6="","-",'P1'!S6:Z6)
When Using the forumala In C# like this
strP1 = txtP1.Text
workbook.range["S6"].Formula = "";
In Place of P1 in the formual I need to use strP1 but i unable to change the formual in C# string format:
This is what I tried: " =IF('"+strP1+"'!S6:Z6="""+ +'"','"'-'"','"+strP1+'"'!S6:Z6) ;
Can someone help me with this..Thank You
Go to the complete details ...