-sign
 

I have5 columns a b c d e
I would like a formula to work out and show a minus sign if the total of
cell d is greater than the total of cell a, if cell d is greater that cell a
just the difference,
ie a100 a10
d101 d 9
e -1 e 1

-sign
 

=A1-D1

Vaya con Dios,
Chuck, CABGx3



"bbc1" wrote:

I have5 columns a b c d e
I would like a formula to work out and show a minus sign if the total of
cell d is greater than the total of cell a, if cell d is greater that cell a
just the difference,
ie a100 a10
d101 d 9
e -1 e 1

-sign
 

In E1 try

=SIGN(A1-D1)

If this post helps click Yes
---------------
Jacob Skaria


"bbc1" wrote:

I have5 columns a b c d e
I would like a formula to work out and show a minus sign if the total of
cell d is greater than the total of cell a, if cell d is greater that cell a
just the difference,
ie a100 a10
d101 d 9
e -1 e 1