If Statements Returns Both Results Separated By Comma

This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.
If you are using an international version of Windows or have otherwise changed settings in the International Control Panel so that a comma is the decimal separator, as opposed to a decimal point, you may get extra commas from an If statement in the ClarisWorks spreadsheet.

Example:
Cell A1 has the number 12 in it
Cell A2 has a calculation: =IF (A1 , 5,1)

Cell A2 will result in 5,1 if the International Control Panels have a comma for a decimal separator as opposed to a decimal point. Changing the Control Panel settings back to a decimal point fixes the problem.
Published Date: Feb 18, 2012