Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build formula using field values as text in the formula referencing another workbook | Links and Linking in Excel | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |