I am writing a text for young people and adults about spreadsheets.

From an exercise proposed in the text, students are making contact with the "logical operation":

          If [condition] Then [Decision1] Else [Decision2]

This "action" is not working in some cells [not all].

For example, entered in cell  B5  was the "formula"  "=-19,6+23,9" (without the quotes) in cell  D5  type the numeric value was  4.3,  was entered in cell  E5  the formula:

                "=if($D5=B5;1;-0.5) "(without the quotes),

but the value that Gnumeric put in that cell is "-0,5"  when it should be "1".

This occurs in other cells and other cells is the result expected.

This panilha was tested in Excel and BrOffice and ran to the satisfaction.

Attached is a worksheet named "Avaliacao_final.gnumeric"

Thanks for your attention