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

Hi :)
I really prefer the mailing-list / forums method of user-support.  Often people are unclear or 
mis-state what they want and don't understand even what the problem is sometimes.  Tech support 
from a single person, for example telephone support, fails to give the range of different ideas 
that a list or forum generates.  

Good work all! :)
Regards from
Tom :)  


--- On Thu, 24/5/12, JOE CONNER <joeconner2007@gmail.com> wrote:

From: JOE CONNER <joeconner2007@gmail.com>
Subject: Re: [libreoffice-users] Hiding negative numbers in Clac?
To: users@global.libreoffice.org
Date: Thursday, 24 May, 2012, 0:06

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



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


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