Hi Johnny,
Johnny schrieb:
[..]
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
ideas that a list or forum
generates.
Good work all! :)
Regards from
Tom :)
--- On Thu, 24/5/12, JOE CONNER wrote:
From: JOE CONNER
Subject: Re: [libreoffice-users] Hiding negative numbers in Clac?
To: users@global.libreoffice.org
Date: Thursday, 24 May, 2012, 0:06
On 5/23/2012 02:15 PM, J
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
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 n
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
On 05/23/2012 05: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?
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
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,