Ask Your Question

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

asked 2014-11-11 20:42:03 +0200

JuanKa gravatar image

updated 2016-03-06 01:27:45 +0200

Alex Kemp gravatar image

Libre Office Calc, Version , Mac OS 10.9.2

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-06 01:27:57.442112


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

JohnSUN gravatar imageJohnSUN ( 2014-11-11 21:23:21 +0200 )edit

@JuanKa: 1st, upgrade to 4.3.3 (no newer available) from . 2nd, it's LibreOffice, not Libre Office. I'm sure it's not the latter cuz it'd spark trademark court case.

rautamiekka gravatar imagerautamiekka ( 2014-11-11 22:21:57 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-11-12 01:05:07 +0200

Lupp gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-11-11 20:42:03 +0200

Seen: 335 times

Last updated: Nov 12 '14