Comment 0 for bug 152087
Revision history for this message
| Najmudin (hussain-hammady-gmail) wrote IF function cant't be done without Quotation marks | #0 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
67d34a1
(Get the code!)
Binary package hint: openoffice.org-calc
actually this is not a bug , but an important enhancement as i think.
When i try to use the IF function with words for example :
Pass - Fail instead of numbers , you have to do that using the Quotation marks every time with each word it will be like that:
Then_value : "Pass"
Otherwise_value : "Fail"
if you did not put the Quotation marks you will get an error .
When you try to do the same operation in MS Excel there is no need to put the Quotation marks , just write any word you want
and it will give you the correct result.
I think its non sense to make complicated like that it should be easier for the user espcially those who left MS Office to Open Office.
Thats all , and thanks for you efforts people .