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.