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)
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
.
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 ""
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)