Re: [libreoffice-users] Hiding negative numbers in Clac?

On Wednesday, May 23, 2012 07:48:33 PM Jay Lozier wrote:
> On 05/23/2012 07:38 PM, Johnny wrote:
> > On Wednesday, May 23, 2012 04:06:16 PM JOE CONNER wrote:
> > > On 5/23/2012 02:15 PM, Johnny wrote:
> > > > I have a spreadsheet where one cell is defined by several others with a
> > > > subtraction of a number hard coded in there.  The cell displays the
> > > > negative number when all other cells are blank.  Is there a way to not
> > > > display negative numbers in a cell?  The outcome of the cells will never
> > > > be negative, once the proper values are entered, so that won't be a
> > > > problem.
> > >
> > > You want the ABS function:
> > >
> > > =ABS(-56) returns 56.
> > >
> > > =ABS(12) returns 12.
> > >
> > > =ABS(0) returns 0.
> > >
> > >
> > >
> > > Joseph E Conner
> > > Poulsbo, WA USA
> >
> > I want nothing displayed if the other cells have nothing in them.
> >
> > A1 = 10
> > A2 = 20
> > A3 = 30
> > A4 = sum(A1 + A2 + A3 - 5)
> >
> > Prior to entering data into A1 thru A3, A4 will display -5.  I want A4 to
> > be blank, or at least appear so until something is entered into A1,2 or 3
> > that will bring A4's value >= 0.
>
> in A4 =if(sum(A1:A3,-5)>0,sum(A1:A3,-5),"")

Thanks Jay, that did the trick.



-- 
For unsubscribe instructions e-mail to: users+help@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