This formula "=IF(G659=true,NOW())" gives me this error... "#name?"... How do i solve it?

[JuanKa]

Libre Office Calc, Version 4.0.2.2 , Mac OS 10.9.2

[JohnSUN]

May be =IF(G659,NOW(),"")?

[rautamiekka]

@JuanKa: 1st, upgrade to 4.3.3 (no newer available) from http://donate.libreoffice.org/home/dl/mac-x86_64/4.3.3/en-US/LibreOffice_4.3.3_MacOS_x86-64.dmg. 2nd, it’s LibreOffice, not Libre Office. I’m sure it’s not the latter cuz it’d spark trademark court case.

[Lupp]

1. The logical constant saying “yes” will be produced by the function call TRUE() (parentheses empty). Without the partentheses “true” has no meaning in Calc except you have defined in advance a named range/expression with this name yourself. Finding undefined names in an expression the evaluator will return “#NAME?” as an error indicator.

2. Your example is lacking an expression to apply in the case the condition is FALSE. This won’t cause an error recognised by Calc. It will just return the logical value FALSE() (then displayed in a way depending on the number format of the cell) if the condition is FALSE. Most likely this is not what you want.

3. If G659 is actually containing a logical value in its correct variant (numerical value 0 for FALSE and 1 for TRUE) the expression “G659=TRUE()” will return exactly the same result as a simple “G659”.