Hi,

I have created an invoice which works perfectly on my Windows 8.1 PC but the same invoice won't work in my Windows 10 PC.

The problem I have is that I receive a syntax error with the formula on the Windows 10 pc.

The formula is =PRODUCT(A2,C2)  which multiplies the 2nd line of column 1 with the 2nd line of column 3.

The only way it will work is if I change the comma to an apostrophe i.e.: =PRODUCT(A2;C2) this then works perfectly but it means that I can't edit any invoices on the other machine if I change the template. 

What I would like to know is how can the syntax be different from one machine to another? 

Have I missed some setting?

Any help would be greatly appreciated. 

(both machines have been fully updated with office and windows updates)

Kind Regards Wayne Lal-Singh 

• Edited by arcadian212 Wednesday, August 05, 2015 10:36 PM

The error is due to your regional settings. You can overcome this by not using PRODUCT; instead you can use nothing more complicated than a field coded as:
{=A2*C2}
Such a construction will give the correct result regardless of the PC's regional settings.

Thank you so much. It works!!