On Sun, 21 Jun 2015 21:52:53 +0100 Brian Barker <[email protected]> wrote:
> At 21:11 21/06/2015 +0100, Pete Nikolic wrote: > >At 19:31 21/06/2015 +0100, Pete Nikolic wrote: > >>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. > > > >I have managed to get round it right now using > >=IF(COUNT(D10-K10)=2,D10-K10,"") > >That seems to do the job ... > > I fancy you mean > =IF(COUNT(D10,K10)=2,D10-K10,"") > - with a comma, not a minus sign. > > Brian Barker > > Yep you got it typo on my part ... Pete . -- Illegitimi non carborundum . ro for the purists out there Noli nothis permittere te terere. -- To unsubscribe e-mail to: [email protected] 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
