# How To Change Positive Into Negative Number Inside Cell Formula

Feb 7, 2014
How do I change a Positive number into a Negative number inside a cell formula?

I have a figure in Cell AE 101 which has the positive number 141

I have another cell W1 which has the positive number of 437

I want to create a formula in cell X1 that takes the number in cell AE 101 of 141 and convert the number inside the formula of 141 into a negative number of -141 and then subtracts that number from Cell W1 of 437 leaving an equation inside the formula to read. 437-141 = 296

Since the number in Cell W1 changes all the time and the number in AE101 Changes all the time the new formulated number in X1 will change all the time too as the cells get updated.

View 6 Replies
ADVERTISEMENT
Dec 6, 2007

I am wanting to finish a worksheet for my boss. What I have done so far is taken the " forecast" of vehicles shown and used a formula of subtract from "actual" vehicles sold to get "how many we have left to go". what he wants to do is have the "to go" number change from red when a negative to green when it reaches a positive. example:

forecast = 30

actual = 27

to go = -3

that "to go" needs to be without a negative sign but in RED to negate a negative. Is that possible with a formula??

View 2 Replies
View Related
Dec 26, 2006

This may be more of a math question rather than an Excel one.

If I have a spreadsheet with a cell that produces different negative number each time it is used, is there a way i can add a formula to make it a positive number.

So if Cell A1 showed -£244.22, I want to add an equation that changes if to £244.22

Cell A1 changes so it would need to do the same for any negative number within that cell.

View 10 Replies
View Related
Aug 27, 2012

I am looking for a conditional formula that can be applied to a cell so that when I enter a number with a positive value, it:

1) Converts it to its negative equivalent value.

2) Displays in the value in the cell with parentheses around the number to indicate that the value is negative.

I am trying to do this without having to reference another cell to provide the entry or display the outcome.

View 1 Replies
View Related
Jan 16, 2008

I have a worksheet in which the values in cells B8, H37, H42, H48 and H49 must be negative. Occasionally the values get entered as positive numbers.

I would like to use VBA code to automatically change the value from positive to negative.

It appears that the WorkSheet_Change event could be used to do this but I don't know what code to enter into the Sub.

View 9 Replies
View Related
Jul 3, 2006

I have excel sheet with colored cells.

Positive cash flow cells all have green background,

Negative cash flow cells, all have red background.

I calculate all the "sub- total" columns into one "total sum" cell. Based on this "total sum" I want the cell background to be red if the total sum is negative, or green if total sum is positive. How do I make the cell change to the proper background color based on whether it's a negative or postive total sum?

View 2 Replies
View Related
Dec 8, 2013

My goal from image is to enter a number for example in cell F4 and have in appear in L6 so simply L6=F4 but I want it to be negative if cell M2 reads "Outgo" and positive if cell M2 reads "Intake" as selected from the list. Is this possible?

View 5 Replies
View Related
Dec 4, 2013

I am using the following code to update an invoice summary sheet from an invoice sheet but when a Credit Note is issued I would like the Nettï¿½ value copied across to be a negative figure. When a credit note is issued the value of Service Invoice Cell L2 = 2 and an invoice L2 =1.

VB:

Sub UpdateSummary()

' Updates Summary Sheet with Invoice Details

Dim InvoiceDate As Date, InvNo As Integer, JobNo As Integer, Company As String, Location As String, Nettï¿½ As Currency

[Code].....

View 4 Replies
View Related
Aug 25, 2009

I have a cell that always requires a negative currency number.

No doubt I will inadvertently enter a positive number now and then.

Is there a conditional format method or something that will take my cell entry and always change it to negative?

View 13 Replies
View Related
Feb 6, 2007

I use data on a text file and import this into Excel and use a macro to format. The data lists invoices and credit notes and their dollar value.

Due to a fault in the program that creates the text file all dollar amounts are shown as positive figures. Credit note amounts should correctly be shown as negative figures.

The invoice number format is 8 characters beginning with a letter and credit notes begin with a number.

Is there macro code that will change credit note values to a negative figure?

View 9 Replies
View Related
Nov 20, 2007

I have a series that comprises of two rows:

Row 1 is date

Row 2 are values

I am trying to find a formula where I can identify where in row two the value chages from positive to negative, and where it changes from positive to negative it should return the date the value changes from positive to negative ie:

ROW 1 08-Jan 09-Jan 10-Jan

ROW 2 1111 22222 -33333

The formula should identify that in row 2 the negative value occurs at -33333 and at the 10th of January.

View 5 Replies
View Related
Sep 1, 2007

I have data starting in E7. I want it to go down the column and find the negative numbers. If it finds one then I want it to change the number in the row to the left of it to a negative. So if E67 is a negative number, make D67 a negative and so forth down the line Sounds "simple" but how do I do it?

View 7 Replies
View Related
Nov 12, 2012

I keep getting the correct answer, but it returns it as negative and I need a positive answer.

View 1 Replies
View Related
Apr 3, 2014

Here it is i needed to get the total of all negative and positive value.

View 2 Replies
View Related
Oct 25, 2007

In one column, I have a formula that will produce a positive or negative number. If the number is negative, I want it to be automatically transfered to the adjacent cell/column. I don't want a positive number transfered though.

View 9 Replies
View Related
Aug 21, 2014

I go negative in one column I want it to show up in the next column as a positive number because when I add my income and subtract my bills and the negative from last month to get the what cash I'll have left it screws up because negative subtract a negative is a positive. So how do i get the sum of say B9 to from -$5.00 to +$5.00 into C4 so when i subtract C4 From my income it wont add to it.

View 1 Replies
View Related
Aug 22, 2008

I need to have a formula or code so that when a number is entered in cell E12 or F12 or L12, or M12 would treat a positive number as a negative and a negative number entered would be a positive in that respective cell.

View 9 Replies
View Related
Jan 15, 2008

I am using a regular expression in a function to extract numbers from strings. the code I am using is below.

Function ExtractNumber(rCell As String)

Set RegEx = CreateObject("vbscript.regexp")

RegEx.Pattern = "d*.d*"

If RegEx.Test(rCell) Then

ExtractNumber = CDbl(RegEx.Execute(rCell)(0))

Else

ExtractNumber = vbNullString

End If

End Function...

View 3 Replies
View Related
May 29, 2013

Can I use Conditional formatting (highlights duplicate values) but highlight the number even if the number is an Positive or Negative number.

It must highlight the number if it's -300 or 300 in both instances.

View 6 Replies
View Related
May 2, 2007

Let's say I have a column A with the following values.

30

40

30

60

-20

-10

-50

-60

-70

120

320

20

-40

-30

40

How can I have 2 cells display:-

i)highest streak of positive numbers = 4

ii)highest streak of negative numbers = 5?

Also, how can I have another 2 cells display:-

iii)the sum of the highest streak of positive numbers = 160

iv)the sum of the highest streak of negative numbers = -210

View 6 Replies
View Related
Dec 5, 2011

I have a column of numbers that are derived with a formula. I need to Average only the ones that either have a Positive or Negative number, ignoring blanks or zero.

I have tried Search but couldn't find anything that address both blank and zero.

Sheet2

K610.00%624.76%632.53%6418.75%65666.38%6768-4.00%6970-5.84%710.86%

Excel tables to the web : [URL] .......

With this small sample, the answer should be 3.35% according to Excel when I choose just those neg and pos cells.

View 9 Replies
View Related
Apr 22, 2014

count if fuction on positive and negative number in the attached excel sheet. I would like to count how many numbers are positive and negative in the A column of the attached excel sheet.

View 4 Replies
View Related
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."

View 7 Replies
View Related
Jul 17, 2013

I have the following formula

=IF(VLOOKUP(F89,'2013 susp 2714035 Reissues'!F:F,1,FALSE)=F89,"yes",FALSE)

That is supposed to look at the tab 2714035 Reissues and find the same dollar amount. The issue Iam having is the dollar amount can be a negative or a positive amount but the formula is only picking up the number if it matches exactly negative to negative or positive to positive. formula to pick up the matching number if its a negative or a positive.

View 1 Replies
View Related
Jan 3, 2012

I need formula for if cell value = negative number e.g.(-2202) change cell value to 0

View 5 Replies
View Related
Jan 24, 2014

I've got 12 months worth of business accounts which have been downloaded onto a single spreadsheet.

These show negative and positive values. As I only want to work on the negative figs at the moment, how do I highlight the colour of the positive value cells or font to prevent any mistakes ?

View 1 Replies
View Related
May 11, 2006

if c12 = $(55.63) which is a negitive value i wont d12 to display OWE.

if c12 = $55.63 which is a positive value i wont d12 to display CREDIT.

These value can vary

View 5 Replies
View Related
Feb 1, 2007

I know ASAP has a feature to do this but I need the code in a bigger macro that I wrote.

EX: -1 needs to be 1

View 9 Replies
View Related
Jan 19, 2009

In my first column I will be entering both negative and positive numbers. In the cell next to it I need the amounts to all show as positive only. So both negative numbers and positive in the first column will all show as positive in the adjacent column/cell.

View 2 Replies
View Related
Mar 15, 2012

I have created a template using data validations. I have a drop down in column O, which you can choose from Credit or Charge. In column V, I want:

- If selected Credit in column O, only negative numbers allowed in column V

- If selected Charge in column O, only positive numbers allowed in column V

View 2 Replies
View Related