https://community.sap.com/t5/application-development-and-automation-discussions/problems-with-some-formulas-in-excel-ole2-object/m-p/8216115#M1627829 <HTML><HEAD></HEAD><BODY><P>are you using semi colons between your parameters in the formula, rather than commas?</P></BODY></HTML> Thu, 29 Sep 2011 17:47:27 GMT Former Member 2011-09-29T17:47:27Z https://community.sap.com/t5/application-development-and-automation-discussions/problems-with-some-formulas-in-excel-ole2-object/m-p/8216114#M1627828 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>I need to write the several formulas inside some cells in Excel. Simple arithmetic like "=X1<STRONG>$Y$1" works fine, but i got fail with some built-in excel function. When i try to write formula which contains "ROUND" (f.e. "=ROUND(X1</STRONG>Y2;2)") or "VLOOKUP" (f.e. VLOOKUP(U9;W:Y;3;FALSE)) functions i receive SY-SUBRC = 3, and then cell is empty. But for example "=SUM(X1:X100)" works without any problem. </P><P>I use SET PROPERTY OF g_cell 'Formula' = form. I use Excel 2010.</P><P></P><P>What is the problem?</P><P></P><P>Thanks in advance.</P><P></P><P>Edited by: Vl89gm on Sep 29, 2011 7:30 PM</P></BODY></HTML> Thu, 29 Sep 2011 17:27:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problems-with-some-formulas-in-excel-ole2-object/m-p/8216114#M1627828 Former Member 2011-09-29T17:27:41Z https://community.sap.com/t5/application-development-and-automation-discussions/problems-with-some-formulas-in-excel-ole2-object/m-p/8216115#M1627829 <HTML><HEAD></HEAD><BODY><P>are you using semi colons between your parameters in the formula, rather than commas?</P></BODY></HTML> Thu, 29 Sep 2011 17:47:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problems-with-some-formulas-in-excel-ole2-object/m-p/8216115#M1627829 Former Member 2011-09-29T17:47:27Z https://community.sap.com/t5/application-development-and-automation-discussions/problems-with-some-formulas-in-excel-ole2-object/m-p/8216116#M1627830 <HTML><HEAD></HEAD><BODY><P>You are genius. I changed ";" to "," in formulas and it works. Great thanks.</P></BODY></HTML> Thu, 29 Sep 2011 18:08:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problems-with-some-formulas-in-excel-ole2-object/m-p/8216116#M1627830 Former Member 2011-09-29T18:08:56Z