+ as well as - in front of difference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Turnipboy - 29 Dec 2005 13:31 GMT

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.

Signature

Turnipboy

Reply to this Message

René - 29 Dec 2005 13:43 GMT

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

Reply to this Message

Turnipboy - 29 Dec 2005 13:51 GMT

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

Reply to this Message

Bernard Liengme - 29 Dec 2005 13:53 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

Reply to this Message

Turnipboy - 29 Dec 2005 16:01 GMT

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

Signature

Turnipboy

Reply to this Message