Hi Pete,
pete nikolic schrieb:
Hi All ..
Having a problem here that is becoming a real PITA situation .
I am running Libre office Version 4.3.7.2 on Arch Linux
I have a lot of cells with this or similar in
=IF(D10-K10>0,D10-K10,"")
the problem is that if either D10 or K10 is blank the result is displayed as
#VALUE! that means several hundred times not only is it a pain but it mucks the
printing up as well the results do not look good covered in #VALUE! .
If the cells are really empty, that should not happen. I guess, that the
cells are not empty, but contain a "Blank"-character or an empty string.
In that case Calc tells you, that it cannot calculate with text.
What is the trick to preventing the display of aforementioned string
You can force the cell entries to be treated as numbers in a way, that
text is treated a zero. That is done automatically if you use functions
with an array as parameter oder explicitly with the function N.
=IF( N(D10)-N(K10)>0; N(D10)-N(K10);"")
For me the delimiter is a semicolon, I'm not sure about your comma as
delimiter.
Kind regards
Regina
Thanks
Pete .
--
To unsubscribe e-mail to: users+unsubscribe@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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.