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

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.


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