[libreoffice-users] Preventing the display of #VALUE! in a spreadsheet

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+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