Here is an example: =IF(ISNA(A1); "None"; A1)
See the Information Functions on this page for more http://www.techonthenet.com/excel/formulas/index.php -- View this message in context: http://nabble.documentfoundation.org/Test-for-Error-Conditions-in-Calc-tp2982777p2983265.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted