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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
