Issue 123230 - The function IF result in #RIF error if a confront string is 'KB'
Summary: The function IF result in #RIF error if a confront string is 'KB'
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.0.0
Hardware: All Windows 8, 8.1
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2013-09-10 17:07 UTC by Gilberto
Modified: 2017-05-20 09:54 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Gilberto 2013-09-10 17:07:52 UTC 
Enter 'KB' in IF function on a cell generate #RIF error instead of correct result.

Example normal: the formula =if(G2='GB';1;2) results 1 or 2 if cell G2 is equal or different to 'GB'.

Example with wrong result: the formula =if(G2='KB';1;2) results always #RIF.
Comment 1 Regina Henschel 2013-09-10 17:16:20 UTC 
Are you sure about the single quotes in 'GB' and 'KB'?

Please attach a small document, which shows the error.
Comment 2 Edwin Sharp 2013-09-11 06:46:56 UTC 
=if(G2='KB';1;2) gives #NAME?
=if(G2="KB";1;2) gives correct results.

Rev. 1520602 Win 7
Comment 3 Gilberto 2013-09-11 09:43:55 UTC 
sorry for the waste of your time. Today my fresh mind do not find any problem. Yesterday evening I was convinced that the function builder automaticly tranlated the double quote to a single one. But today is not, so it's my fault.
Sorry again, thanks
Gilberto