+ as well as - in front of difference

T

Turnipboy

I am working out the difference of two numbers and I would like the
answer to keep a + as well as a - (the minus it does automatically) in
front of the answer, how can I do this.

Thanks.
 
R

René

If the two numbers you want to have the difference from are in cells A1
and A2, then:
=IF(A2-A1<0;"+/"&A2-A1;A2-A1)

Good luck,
René.
 
T

Turnipboy

Thanks. I also want to put a plus and minus infront of some other numbe
(they are not simple differences), I remember someone showing me how t
do it in number formatting and a plus or minus appears infront of th
number depending on wheter it is positive or negative
 
T

Turnipboy

Thanks Bernard, this is exactly what I had in mind, even though I had
forgotten it! Thanks to all of you for your help.
 
Top