To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=46525
User dr changed the following:
What |Old value |New value
================================================================================
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Apr 4 09:41:55 -0700
2005 -------
If Calc sees a text in the conditional part of the IF function, it uses the
FALSE value (3rd parameter). Excel always sets a #VALUE error.
What do you want to do in this document? Why do you test on a text value in the
IF function? That is not the purpose of this function. For example, in cell D2,
there is the formula
=IF(A2;"Nikah";140%*C2)
Did you want to write something like
=IF(A2="Nikah";140%*C2;0)
instead? That means: If A2 contains "Nikah", set 140% of C2, otherwise set 0 as
result.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
