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

On Sun, 21 Jun 2015 21:52:53 +0100
Brian Barker <b.m.barker@btinternet.com> 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: 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