No error, but sum don't show up?

The last part of this formula don’t show up in the cell (see pink area in enclosed sample)
=IF(F3>0;F3;G3+H2)

So IF(F3>0;G3) is okay, but the result of G3+H2 is not visible

Any idea what’s wrong?
Test.ods (13.7 KB)

May be so =IF(N(F2)>0;F2;N(G2)+N(H1)) ?

Thank you.
Can you explain to me what the “N” does in this formula?

Is it really? If I delete F3 then the formula works. I think you need =IF(F3>"";F3;G3+H2) because F3 is currently ""

Yeah, you’re right. That have to be a bug.

I am not sure that it is, "3" makes the 3 into text, so =""+1 returns #value.

From Information Functions

N Function
Returns the numeric value of the given parameter. Returns 0 if parameter is text or FALSE.
If an error occurs the function returns the error value.

So it will return 0 instead of the text ""

1 Like

The funktion

=N()

outputs “0”, if input is not a number.


The funktion

=VALUE()

outputs “error:502”, if input is not a number.


not explained in LibreOffice-Help v.25.2 I am using! (or I can’t find anything I have looked for the function =N() )


subsequently added: ‘…outputs “0” (ZERO)…’, which strictly speaking is not a number but logical 0 = electronic Low level = “FALSE” truth value, respectively “1” = High level = “TRUE”;
in other words: “0” = NaN (is not a number)

The help page has “Refer to the VALUE wiki page for more details about this function” at the bottom. And indeed, the latter has “If Text does not contain a number, date, time, or date-time in a recognized format (which may depend on locale), then VALUE reports an invalid argument error (Err:502)”.