showing plus sign

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get a "+" sign to show up when I do a formual =a1-b1. The minus
sign shows up, but I would like to see the plus sign for positive results.

Thanks
 
I'm sure there's probably another way, but one way:

=IF(A1-B1>0,"+" & A1-B1,A1-B1)

HTH,
Paul
 
The "+" sign is not used within Excel - like in Lotus (if that is what you
mean)..
All formulas should begin with the = character.
In a blank cell entering 123 (assumes a positive (+) sign).

It is used like in this case,

In Cell A3 enter:
=A1+A2
 
How about going into Format - Cells - Number, select Custom, and type in
+0;-0 and create your own personal Custom format?

Good Luck!
 
You could give it a custom format:
Format|Cells|number tab|custom category:
+General;-General;0;@

(positive;negative;0;text)
 
If I understand correctly, you want the results of a formula to show either a
negative or positive sign before the number... so if A1-B1 where a negative
2, it would look like this: -2 and if it were positive it would look like
this: +2.
If that's what you are looking for, select the range containing your results
and choose Format, cells, number tab. Select Custom as the number format
(it's at the end of the list) and enter this:
+#,##0.00;-#,##0.00;0.00
this custom format would display numbers with commas as needed, a decimal
and two decimal places, with a + for positive and a - for negative and 0.00
for results of zero. If you need your results to appear differently, change
the custom format accordingly.
For example:
+#,##0;-#,##0;0
would display with no decimal places, but with the positive and negative
signs... and zero would simply be 0.
Remember that formatting to reduce decimal places does NOT (usually) change
the value, only the appearance.
Good luck!
 
Back
Top