+ as well as - in front of difference

[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.

 

[=?iso-8859-1?B?UmVu6Q==?=]

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é.

 

[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

 

[Bernard Liengme]

A custom format such as +#,##0;-#,##0 or +0, -0 will work
best wishes

 

[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.