Jan 10, 2008

In a formula, what effect does putting a plus sign after an equals sign? e.g.
=+((1+B8)^12)-1. I orginally assumed that it made sure that result the would always be positive but I was wrong.

Sep 29, 2006

My boss uses the + symbol and the = symbol in his formulas eg "=+E3*E4" What is the advantage or difference in this as to just using "=E3*E4"

## Decimal Sign Replaced With ';' Sign

Dec 8, 2009

I'm trying to solve a strange problem in a piece of code.

I have a variable that is define as Double called STD. When i try to insert that variable in a formula the decimal sign (for me a comma "," because I'm Portuguese) gets converted to ";" (which is for me the separation sign for the expressions in excel formulas. ex: AND(A1>0;B1>0)=TRUE). The code is:

## IF Formula Changing The Sign

Apr 8, 2009

I need a formula that reads If a number is less than zero then it will show as positive, but if the number is greater than zero then it will show as a negative.

## Get Formula In A1 Without Equal Sign?

Jul 11, 2012

i want formula in b1 to get the formula in a1 without Equal Sign

A1=(A2*A3)+2

Reults B1 should be (A2*A3)+2

## How To Show Minus Value In A Formula As Plus Sign

May 31, 2014

I have attached here an excel sheet with some data. I need to show the minus value in D5 as a plus sign, is there any conditional formula to work this out??

Jan 26, 2014

I want to know how many emails are in my list. There is dash sign where the emal id is not available. The subtotal formula gives me the total entries in range but I want to know only email count numbers.

In my range there are 6 entries and only 4 email ids. Now I'm getting output 6 but I want it 4 ignoring 2 dash signs.

## Formula To Sum All Numbers With Same Sign (negative / Positive)

Jul 23, 2012

I am looking for a formula to do the following:

In Tab 1, I have a negative number and the word "Original" next to it. In Tab 2, I have a mix of positive & negative numbers. I want all numbers that are negative to display the word "original" and all positive to display" new." How do I do that? Also, I want the opposite to work as well-- if Tab 1 has a positive number, I want all positive numbers in Tab 2 to display "original."

## Concatenate Formula Not Taking Decimal Places/currency Sign

May 26, 2009

i have lets say a table with rows that contain the following data.

SKU - PRICE - SALEPRICE - DESCRIPTION - SALEDESCRIPTION

What I am trying to do, is to make a concat formula that says:

SALEDESCRIPTION = DESCRIPTION+price was+PRICE+now+SALEPRICE

In essence so that i can simply pull down the formula, and all our product descriptions have 'special offer, was xx (price) is now xx (sale price).

This works fine, except that in the SALEDESCRIPTION, the amounts from the price and saleprice fields are being brought over without decimal places and without currency symbol.

I have tried formatting those two columns as currency or accounting but neither works.

## VBA For Value Sign Change

Jul 8, 2012

Having trouble applying a name to the line

For Each ctrl In Form1.Controls

The name of my Form is "frmLayout"

How can I change Form1.Controls to "frmLayout".Controls ?

don't tell me just to type in it without the quotes, I mean when the name is in a string variable.

## Currency Sign

Sep 15, 2008

I have a very frustrating problem with my business plan i am writing in Excel. every so often it crashes and when I open it again all the £ signs have turned to \$ signs and i have to go through and painstakingly change them all. This also happens even if I just close the file carefully and open it up again. I have tried looking in preferences to see if there is a default setting but can't seem to work it out. can anyone help me with this tiresome issue?

## Red Negative With £ Sign

Oct 24, 2008

is it possible to display the value in a cell with a £ and also make it automatically go red when the sum is negative?

## How To Remove = Sign

Nov 18, 2009

looking for a formula to remove an "= sign" at the very beginning. hence if "=Jordan" then want to change it to "Jordan" in cell T3 only.

but wait, the resulting cell T3 "=Jordan" already has a formula inside it =(U3&V3&W3&X3&Y3)

How to enter formula for removing "= sign" and not disturbing the existing formula ....

Aug 6, 2014

=D7
=E7
=F7

so result:
= \$E\$7
= \$D\$7
= \$F\$7

A solution would be to use the "F4" every cell, but the process requires more time.

I tried to select multiple cells and press "F4" but do not works.

## Plus Sign Barcode Conversion

Mar 6, 2008

Why when I convert the following data, why the plus sign "+" converts to a /K?

I'm trying to convert values in groups of cells to a 3 of 9 barcode.

The value would be something:

+R4235

But when the font is changed to a 3 of 9 barcode and then I test the barcode in Notepad I notice that the plus sign is replaced with a /K.

Jul 29, 2008

I want to save phone no as +99 9876543210 in excel 2003 on my xp pro machine. But if i give a + sign in the cell, some blue dotted rectangle shows up and everything messes up.. I think it is treating it as a formula or something... how can i save this in the cell. tell me in detail if you are going to tell me about macros or vb code as I don't know how to insert code or program macros.

## Showing WithOUT A Dollar Sign

Nov 12, 2008

I am a new user both to Excel and these forums, but I am very glad they both exist! What I have is this (it is C13 for those playing at home):

## Special Sign Removal

May 27, 2009

I got three columns in excel. Column A is a list of items, so is column C. Column B displays the similarity in the 2 lists.

I use the following command =IF(ISERROR(MATCH(A1,\$C\$1:\$C\$265,0)),"",A1).

SO:
A B C

Cat Fish
Dog Dog Roll
Bull Carpet
Apple Dog

But what I want to do is the following:

If I have "D-og 12 2-3" in column A and say "do g 1 22/3" in column C, I want it to be displayed in column B. To do that I need to decapitalise and remove all the special symbols such as space, ), (, *, &, ^, %, \$, #, @,! etc.

So I get dog1223 in column B since they are the same.

## Convert Sign ( - ) To Value Hex Code

Oct 1, 2009

I have columun in one row, if got sign (-) want convert to value 8,4,2,1 and this value convert to hex code...please anyone give guideline. thanks in advance.i has attach file please have a look.

## VBA Macro - Removing Plus Sign

Apr 11, 2012

Been struggling with the + sign. I have been using code such as shown below, but it just wont work for +.

Selection.Replace What:="~~", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="^", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="~*", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

## How To Predict Next Appearing Sign

Jul 11, 2014

I have my results in cells B2:B55 consisting of three signs which are 1, X and 2.

AB1DateResult218-08-131325-08-132401-09-13X508-09-132615-09-132718-09-132822-09-13X925-09-1311029-09-1321102-
10-13X1206-10-1311313-10-1321420-10-1321523-10-1321627-10-1321730-10-13X1803-11-1311906-11-1312010-
11-1312117-11-13X2224-11-1312327-11-1312401-12-1312508-12-13X2611-12-1322715-12-1312818-12-1312922-
12-1323005-01-14X3112-01-14X3219-01-1423326-01-1423402-02-14X3509-02-1413616-02-1413719-02-1423823-
02-14X3926-02-1424002-03-14X4109-03-1414216-03-1414323-03-1414426-03-1414530-03-14X4606-04-1414713-
04-1424820-04-14X4927-04-1425004-05-1425111-05-14X5218-05-1425325-05-1415401-06-1415508-06-1415611-07-14?Sheet1

Is there any way the next falling sign can be predicted in cell B56? And if so, what would be the measures to guess the next sign?

## Place The Name Before Equal Sign

Oct 26, 2009

I'm trying to simplify a section of my code by naming a long string that is repeated. I tried by simply place the Name before equal sign (=) and also putting Set before the name. Both failed though I've seen both methods used successfully in other code. Am I having a syntax issue of some sort?

Private Sub ConditionalRowDelete()
Dim NumRows, iLine As Integer
ActiveSheet.UsedRange.Select
NumRows = ActiveSheet.UsedRange.Rows.Count
Dim CircuitType As Range
Set CircuitType = Range("C" & iLine).Value
For iLine = NumRows To 2 Step -1
If Range("A" & iLine).Value > "6999" Then
Rows(iLine).EntireRow.Delete
End If
Next iLine
For iLine = NumRows To 2 Step -1
If CircuitType = "VOIP" Or CircuitType = "Customer Care" Or CircuitType = "Dialup" Or CircuitType = "IRU" Then
Rows(iLine).EntireRow.Delete
End If
Next iLine
End Sub

## Extract The Numbers Following # Sign

Dec 23, 2009

This should be an easy one but I am having a difficult time extracting the digits after the # sign in each account description in my list. The values in each cell do not follow any rhyme or reason and differ in length. Three examples of the current data and what I am looking to extract are below.

Current Data:
ALBERTSONS #8272-ROSEVIL WHS-closed
ALBERTSON'S #703 - SAN RAMON
ALBERTSONS #7105 - CARMEL (SOLD 6/06)

Extract Needed:
8272
703
7105

## What Does The Dollar Sign Denote?

Jul 20, 2006

what is the specific indication of marking a range with dollar sign (\$)? in other words, what is the difference between '\$a\$1' and 'a1'?

## Prevent Copy From Using \$ Sign

Jul 24, 2006

Get a SUMIF formula to work, which it now does, but the formula puts '\$' signs in the range, so that when it copies it, it does not change the range. I have got round this, by defining 12 separate ranges. But it does make the code rather long winded. Anyone know how to put the formula in without the '\$' signs? There must be a way to put the formula into the first cell, and copy it across?

Set Rga = Range("b6")
Set Rgb = Range("b6").End(xlDown)
Set Rgd = Range("\$e\$6")
Set Rge = Range("\$e\$6").End(xlDown)
Set Rgc = Range(Cells(6, 2), Cells(6, 2).End(xlDown)).Offset(0, 3)
Set Rgh = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 3)
Set Rgi = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 4)
Set Rgj = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 5)
Set Rgk = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 6)
Set Rgl = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 7)
Set Rgm = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 8)
Set Rgn = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 9).............................

## Sign & Sumproduct Functions

Mar 12, 2007

I have three pages of daily data I am working with; orginal source data, manipulated data, and my output. My output data is a daily row of six columns containing 1, 0, or -1, based on my manipulated data (1,1,0-1,1,-1). I would like by row, sum the coresponding source data (5,4,0,-3,3,-4) by the positve 1s and a second column with the negative 1s. then average the column by the number of consituents (positive5+4+3 )/3=4 & negative;(-4+-3)/2=-3.5)

## Display + Positive Sign

May 30, 2007

What number format would I use to display a + positive sign and a - negative sign?

Example:
-17.4 displays as -17.4
74.1 displays as +74.1

Oct 9, 2007

I have this code that reads below,What is the # used to refer to?

Redim qtf(1# To N)
Redim FVec(1# To M)

.....

If N <= 0# Or M < N Then
Info = -1#
.....

## Count Repeating SIGN Cells Only

Jan 9, 2014

I have a column that tells whether an adjacent cell is positive or negative. I'm trying to come up with a macro/formula that will tell me how long (# of rows going down) a negative or positive sign repeats before changing.

So it would go down the column and count the rows where the same sign repeats. Once the SIGN switches from + to - or - to + the number goes back to 0. Essentially counting the cells that move in one direction (+ or -).

For example. if A1 = +, A2 = +, A3 = +, A4 = +, A5 = -, A6 = + then it would count A1:A4 and output 4 in B4, meaning that the numbers have stayed negative for 4 rows. For A4:A5 nothing should appear as this sign change we don't want to record. Same for A5:A6. I don't know how to make a formula/macro to identify a repeating SIGN, and then dynamically count all those rows until the sign changes. Does this make sense? I've been beating my head against the desk trying to figure it out with no luck.

## Currency Convertor (\$ Sign Doesn Not Appear)

Sep 30, 2009

I have a spreadsheet with cells defined as Euro & Dollars. I want to add an automatic conversion so for example, if a cell is defined as \$ the formula will return the sum X 4 and if it is Euro than sum X 5.

I tried to use "if" combined with "search" (so if the cell contains "\$" multiply by 4) but since the cell is defined as currency the \$ sign does not appear and cannot be searched…