On Wednesday, May 23, 2012 07:48:33 PM Jay Lozier wrote: > 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),"")
Thanks Jay, that did the trick. -- 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
