This formula (in Dutch)
=ALS(A5=C2;(ALS(C4=A6;-B5-B6;0));0)
generates ONWAAR (untrue), while the values in the cells are equal. Second problem is that I expect to get a numeric outcome, but I only get ONWAAR.
It is not a Boolean!
The values in the cells are letters and not numbers. Does it make any difference?
Do you expect me to change my user interface to Dutch?
The formula =IF(A5=C2;(IF(C4=A6;-B5-B6;0));0) is containing a redundant pair of parentheses. This doesn’t spoil its functionality, however. If A5=C2 holds and C4=A6 also does, the result must be the value of the expression -B5-B6. In cases where the formula is returning zero the cell may display FALSE if it was formatted in advance ‘Boolen’ (logical) under ‘Numbers’. This is sometimes caused inadvertently when a formula with a Boolean result was entered and later overwritten. This may occur without being noticed when an IF formula first was entered incomplete. A result different from zero will show as TRUE then independent of its exact value.