Formula problem

Jun 12, 2012 at 12:15 PM

Hi, I'm trying to set formula for cell this way:

mySheet.Cell(10, 5).FormulaA1 = "=IF(B15<0;(B15*G15)/(360*100);(B15*F15)/(360*100))";

File is succesfully generated, but when I try to open it, I get the following error:

Excel found unreadable content in 'report.xlsl'. Bla, bla ...

If I accept repairing of file I get this info:

Removed Records: Formula from /xl/worksheet/sheet.xml part

Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)

 

If I try the same formula directly in Excel, it works fine.

I have the same problem with formula like:

=TRUNC(SUMIF(K15:K18;">0");2)

What's wrong?

Please help.

Thank you, Robert.

Jun 12, 2012 at 12:22 PM

Sorry for spamming, problem resolved.

I should use "," instead of ";" in formula ...