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! . What is the trick to preventing the display of aforementioned string Thanks Pete . -- Illegitimi non carborundum . ro for the purists out there Noli nothis permittere te terere. -- To unsubscribe e-mail to: users+unsubscr...@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
