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

Reply via email to