I could not get your prompts to work, but they gave me ideas. The final formula was:
=IFERROR(C30*100/B30,"") This also covered other errors where only one number was present, so no calculation was possible. Many thanks, Tink. -- View this message in context: http://nabble.documentfoundation.org/IF-Function-tp4043493p4043543.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted