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
