I typed the example quoted on line. 5 names in B3 to B7 and numbers in C3 to C7. in D3 I entered =IF(B3=50,“Good”,IF(B3=100,“Excellent”,“Invalid”))
When I press return an extra ) appears at the end. Also I have followed another example using ; instead of , on pressing return ; is automatically replaced by , but not in all instances. Any help welcomed. Thanks.
One ( after each IF, two ) at the end.
And numbers (50, 100) must be in column B (B3=50).
Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions. Please, click edit below your question to add more information.
spyder107,
Please upload your ODF type sample file here.
@LeroyG is correct, in your description you will always get Invalid as it is looking at Column B which contains only names. If I point your formula at column C I get the correct responses. Just the two closing parentheses at the end, no third one added. Cheers, Al
LO 6.4.7.2 on Windows 10 20H2
Check that the (neutral) quotation marks (", Unicode U+0022) are not being replaced by left or right double quotation mark (“and ”, Unicode U+201c and U+201d).
Tested with LibreOffice 6.4.7.2/7.0.4.2 (x86); OS: Windows 6.1.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark (
→ 
) to the left of the answer that solves your question.
If the answer helped you, you can mark the up arrow (
) that is on the left (to vote, you need to have karma of at least 5).
Good point @LeroyG. In Tools > Autocorrect Options > Localised Options untick Replace for Single quotes and for Double quotes
@EarnestAl, Not an AutoCorrect issue. If you began a cell content with =, AutoCorrect don’t work (at least for me).
True. However, I still remember it tripping me up years ago copying formulas from word to excel. I still turn it off and rely on the grammar checker to change the quotes in Writer