-sign

[bbc1]

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

 

[CLR]

=A1-D1

Vaya con Dios,
Chuck, CABGx3

 

[Jacob Skaria]

In E1 try

=SIGN(A1-D1)

If this post helps click Yes