Google Sheets – IF Function Displays Parse Error, What is Wrong?

Thanks to the wonders of floating-point arithmetics,

((0.6-0.3-0.4)+(-0.3+0.8-0.4))

evaluates to approximately -5.55e-17 in double precision. This holds in JavaScript as well as in Google Spreadsheets. It does not really matter whether the computation is client-side or server-side: what matters is the number format used. It appears that Google Sheets use double precision.

The solution is the same: avoid equality comparison for floating point numbers. In your case, changing the units by multiplying everything by 10 would avoid the problem.

In (much of) Europe, formulas need to use semi-colons instead of commas.

So, instead of

=EOMONTH(DATE(1969, 7, 20), 1)

use

=EOMONTH(DATE(1969; 7; 20); 1)

(I presume that this is because comma is a decimal separator for Europeans, while Americans use a period.)

The Google Support page for the EOMONTH function in German shows semi-colons, while the same page in English shows commas. (French is inconsistent, but Spanish and Italian help pages also use semi-colons.)