Tracking weight loss with plus and minus signs

[bobmac1547]

I'm trying to track weight loss, so positive numbers indicate weight lost, and negative numbers are pounds gained. How can I get the numbers to appear such that positive numbers get a minus sign in front and negative numbers get a plus sign indicating weight gain?

[popipipo]

old weight - new weight = weight loss

[Sam Capricci]

assuming your old weight is in A2 and new weight is in B2, then try this... =IF(A2-B2>0,"-"&A2-B2,"+"&B2-A2)

EDIT: actually it may be this now that I think about what you posted on the other thread... =IF(A2-B2<0,"-"&B2-A2,"+"&A2-B2)

[joeu2004]

You neglect to say whether the numbers are integers or, if not, how many decimal places you want to display. One of the following Custom cell formats should do the trick without changing the value or the type (numeric).

For integers:
\-0;\+0;0

For non-integers displaying 2 decimal places:
\-0.00;\+0.00;0.00

Caveat: IMHO, it is misleading to display positive numbers as negative and vice versa. But that is what you asked for.

[bobmac1547]

Thanks everyone. I feel like a real dodo for not thinking of this myself. I guess when you do something, you can get stuck in a rut.

Thanks for getting me out of the rut!