[Bug 1088558] Re: Disability formula IF, Inaccurate and Countless than Microsoft Office
** Attachment added: Inaccurate and countless.xcf https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1088558/+attachment/3456414/+files/Inaccurate%20and%20countless.xcf -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088558 Title: Disability formula IF, Inaccurate and Countless than Microsoft Office To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1088558/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088558] Re: Disability formula IF, Inaccurate and Countless than Microsoft Office
Daniel Yunus, thank you for reporting this and helping make Ubuntu better. Could you please attach the document that demonstrates this problem? ** Changed in: libreoffice (Ubuntu) Status: New = Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088558 Title: Disability formula IF, Inaccurate and Countless than Microsoft Office To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1088558/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088558] Re: Disability formula IF, Inaccurate and Countless than Microsoft Office
** Attachment added: Disability in Discount column https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1088558/+attachment/3456531/+files/Sample%20Disability%20Documents.ods -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088558 Title: Disability formula IF, Inaccurate and Countless than Microsoft Office To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1088558/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088558] Re: Disability formula IF, Inaccurate and Countless than Microsoft Office
Daniel Yunus, the reason you are not getting the expected results is because you encased your ThenValue in quotes, causing to display the text: 5%*H6*I6 Hence, you would want to change the formula in J6 to: =IF(H6=10,5%*H6*I6,0) which displays: $125,000.00 For more on this, please see: http://wiki.documentfoundation.org/EscapingCharacters Thank you for reporting this and helping make Ubuntu better. Please feel free to report any future bugs you may find. ** Changed in: libreoffice (Ubuntu) Status: Incomplete = Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088558 Title: Disability formula IF, Inaccurate and Countless than Microsoft Office To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1088558/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs