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 <[email protected]> wrote: From: JOE CONNER <[email protected]> Subject: Re: [libreoffice-users] Hiding negative numbers in Clac? To: [email protected] 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: [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 -- For unsubscribe instructions 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
