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),"")
-- Jay Lozier [email protected] -- 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
