ExcelBanter - Help with this formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with this formula (https://www.excelbanter.com/excel-discussion-misc-queries/446671-help-formula.html)

s7out

Help with this formula

I need a cell to equal another cell but flip it's "-" value to a "+" and to show it. In other words cell B2 = "-6.5". I need cell H2 to read "+6.5" (with the "+" visable. I normally would have this cell = '+6.5 however since this is a formula I don't know how to achieve the same result. Please advise. Thanks!

Claus Busch

Help with this formula

Hi,

Am Wed, 25 Jul 2012 06:26:55 -0700 (PDT) schrieb s7out:

I need a cell to equal another cell but flip it's "-" value to a "+" and to show it. In other words cell B2 = "-6.5". I need cell H2 to read "+6.5" (with the "+" visable. I normally would have this cell = '+6.5 however since this is a formula I don't know how to achieve the same result. Please advise. Thanks!

try in H2:
=ABS(B2)
and use custom numberformat "+"General"

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Spencer101

Quote:

Originally Posted by s7out (Post 1603973)

In H2 enter =ABS(B2) and then custom format H2 to +#

[email protected]

Help with this formula

On Wednesday, July 25, 2012 9:39:41 AM UTC-4, Claus Busch wrote:
Hi,

Am Wed, 25 Jul 2012 06:26:55 -0700 (PDT) schrieb s7out:

> I need a cell to equal another cell but flip it's "-" value to a "+" and to show it. In other words cell B2 = "-6.5". I need cell H2 to read "+6.5" (with the "+" visable. I normally would have this cell = '+6.5 however since this is a formula I don't know how to achieve the same result. Please advise. Thanks!

try in H2:
=ABS(B2)
and use custom numberformat "+"General"

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

I can't get the + to show. Under Custom in the number formatting options, what exactly do i type in the space to get this to work? Thanks.

zvkmpw

Help with this formula

I can't get the + to show. Under Custom in the number formatting options,
what exactly do i type in the space to get this to work?

I tried
+0.0;-0.0
for the custom formatting type and it seems to display what you want.

Notice that for zero it shows
+0.0
If you don't want the + to show in this case, try this instead
+0.0;-0.0;0.0

All times are GMT +1. The time now is 10:32 PM.