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. -- For unsubscribe instructions e-mail to: users+h...@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
