Hi,
Em 25-05-2011 09:29, Daniel Carr escreveu:
> Please unsubscribe me from receiving these emails. I no longer wish to
> receive them!
You can do this yourself:
Unsubscribe instructions: Send blank e-mail to
users+unsubscr...@libreoffice.org
Answer the confirmation message. Thats it!!
Luiz O
nd value adding enterprise
(156%)
Disclaimer
-Original Message-
From: Jack [mailto:szi...@gmail.com]
Sent: 25 May 2011 14:27
To: users@libreoffice.org
Subject: [libreoffice-users] Re: Test for Error Conditions in Calc
Ron Adams wrote:
>
> How do I leverage IF to replace error conditions
Ron Adams wrote:
>
> How do I leverage IF to replace error conditions, making them instead
> display constant string values? For instance, how would I replace #N/A,
> #NAME and #VALUE with “None”?
>
Some functions you can look into:
ISNA(reference) - [is the reference #N/A ?]
ISERROR(reference)
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 Use