Free Microsoft Excel 2013 Quick Reference

I have in column A formulas e g :

=VLOOKUP(D53,AN54:AO4000,2,FALSE) result -45

=VLOOKUP(D54,AN54:AO4000,2,FALSE) result -67

=VLOOKUP(D55,AN54:AO4000,2,FALSE) result 78

=VLOOKUP(D56,AN54:AO4000,2,FALSE) result -4

=VLOOKUP(D57,AN54:AO4000,2,FALSE) result 49

=VLOOKUP(D58,AN54:AO4000,2,FALSE) result 23

=VLOOKUP(D59,AN54:AO4000,2,FALSE) result - 34

how can I convert negative numbers to positive numbers ?

regards bill

--

bill gras

=VLOOKUP(D53,AN54:AO4000,2,FALSE) result -45

=VLOOKUP(D54,AN54:AO4000,2,FALSE) result -67

=VLOOKUP(D55,AN54:AO4000,2,FALSE) result 78

=VLOOKUP(D56,AN54:AO4000,2,FALSE) result -4

=VLOOKUP(D57,AN54:AO4000,2,FALSE) result 49

=VLOOKUP(D58,AN54:AO4000,2,FALSE) result 23

=VLOOKUP(D59,AN54:AO4000,2,FALSE) result - 34

how can I convert negative numbers to positive numbers ?

regards bill

--

bill gras

- Change negative numbers to positive and vice versa
- Transpose a Negative Number to Positive and Vice Versa
- Transposing negatives to positives and vice versa - VBA
- Change negative numbers to positive numbers
- Formula to convert/transpose columns to rows (and vice versa)
- Excel, change column of negative numbers to positive numbers?
- Formula to convert/transpose columns to rows (and vice versa)
- Information Dump from Vision - Code Help
- Converting Decimal to Binary & vice versa
- Convert Negative Numbers To Zero
- Converting Negative Number to Postive number
- Convert negative decimals to positive
- Change Negative Number to Zero AND apply background color to that cell
- Autocopy specific cell contents from one sheet to another and vice versa
- Converting Negative Numbers to 0's
- Converting numbers to letters
- Negative Numbers to Zero..
- Rounding Negative Numbers to Zero
- Changing the sign of data
- Showing a negative as a positive and a positive as a negative number
- Convert negative to positive in sheet containing both positive/negative numbers
- Converting inputted negatives to positive #'s
- Formula to Roundup Negative Number to zero, and...
- How do I change minus numbers to + numbers in a col in Excel?

Thank you.

Or I enter the positive number 2.5 in F5 and I want the negative number (2.5) to appear in F12.

I can attach a sample worksheet if that would help.

I have the following code to delete all rows containing "Payment" in column D and transposing negatives to positives and vice verca in column H, however it it seems to fall over on the highlighted line with an error 13.

VB:Any Help would be much appreciated, thanks.Formatting_Inputs() Application.ScreenUpdating = 0 With Sheets("Inputs Analysis") With .Range("d5", .Cells(Rows.Count, "d").End(xlUp)) .Offset(, 1).AutoFilter 1, "Payment" .Offset(1).EntireRow.Delete .AutoFilter .TextToColumns Set Rng = .Offset(, 4) [COLOR=#ff0000]mystr = Replace(Replace("|" & Join(Application.Transpose(Rng), "|"), "|-", "$"), "|", "$-") [/COLOR] Rng.Value = Application.Transpose(Split(Mid(mystr, 2, Len(mystr)), "$")) If Application.DecimalSeparator = "." Then Rng.Replace ",", ".", xlPart End With End WithIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Colin

Thank you

Jena

I'm looking for a formula (not VBA nor "Paste Special/Transpose") that would

transpose columns to rows (or vice versa) by simple dragging of the cell.

Are you aware of any, hopefully not too complex?

Thanks a lot for your help on this,

Mark

to positive numbers, what is the easiest way. I tried the paste special

multiply by -1, but it didn't work, I'm probably doing it wrong.

I'm looking for a formula (not VBA nor "Paste Special/Transpose") that would

transpose columns to rows (or vice versa) by simple dragging of the cell.

Are you aware of any, hopefully not too complex?

Thanks a lot for your help on this,

Mark

Ok here's my problem:

I have a dump of information (from a application called Vision) which dumps information from a databse from predetermined filters etc. So there's a couple of things I want to do with that info...

The titles are: Date, Invoice Number, Amount, Description

1) Change all the negatives numbers to positives and vice versa, but only in cells that contain numbers in a specified range

2) The download just dumps the data so therefore I need the invoice number to be displayed as number format, however i've tried the general way of highlighting and changing the format but because it's a dump of info you have to F2 in the cell and enter for it to then be seen as Number rather than General (I hope that makes sence) - the reason for the change in format is because i'm using a =LOOKUP formula to search the invoice number from that array to another...

3) Delete the full row with "PAYMENT" in the description column, but only the cells that actually contain info as in number 1) above

This seems like quiet a lot but I've got some of them working but need it so it's a just a one button job rather then several...

I can send a sample if needed...

Many thanks in advance.

Colin

I was hoping someone would be kind enough to help me out with a small dilemma.

Is there a formala or macro which would enable me to convert an 8-bit binary number to decimal and vice versa.

Example 1. 11111111 =256

Example 2. 00000001 =1

Example 3. 01010101 =85

Basically i want to be able to input a number in to a cell and then select either of two buttons. Button 1 would convert to binary, whilst button 2 would convert to decimal.

It is only necessary to have up to 8 bits of data, although anything above that would be a great asset too.

Just some help with binary. I am placing the headers below.

128 64 32 16 8 4 2 1

Thanks for your help.

Thank you so much for your help!

positive; if you multiply by -1 you loose the decimals (well i do!)

--

with kind regards

Spike

I have a question and I hope someone can help me.

I have a spreadsheet with several columns working together. In one of those, sometimes I get negative numbers so I need to change those numbers into Zero. I already did that with this code (where a=2, is the number of the row) and it work perfect:

--

Sub NegativetoZero()

Dim a As Integer

Dim LastCell As Long

a= 2

LastCell = Worksheets("Sheet1").Cells.SpecialCells(xlCellTypeLastCell).Row

On Error Resume Next

While a

can anyone help me to copy specific cell contents from one sheet to another automatically and vice versa? please see file attached.

thanks,

stoey

I'm looking to establish the most effective way of telling Excel where a value is negative, replace it with 0.

I've achieved this with a custom format but obviously this does not work where the data is required for formulas.

Equally i'm aware that I can make use of an IF() statement to decide if the data is less than 0 and use the appropriate value accordingly. However where i'm using values aggregated using a simple Sum() from other workbooks this quickly creates a very bloated formula, equally I dont want to have to replicate all my Worksheets that have negative numbers to contain a version where negatives are replaced with 0's.

I appreciate this sounds stupid...it's a reporting requirement unfortunately however. I'm trying to maintain a balance between keeping accurate data and generating reports with the negative numbers replaced (and replaced in any calculations).

Suggestions appreciated.

Cheers,

DM

Is it possible to use more than one formual in a cell, such as this formual for cell D33:

=SUM(D30-D32), =IF(D33

formula that will round a negative number to 0 correctly. I used the

(MAX(0,A1) and it seemed to work from that cell but another cell pulls the

value from that cell and it was still using the negative number to calculate.

I need a formula that will round the negative number to Zero and then use

the Zero from that roundup when other cells are referring to it.

Does that make sense?

Need help!!

Thanks,

Robbie

I am trying to change the sign (+/-) of a large table of data because it has been entered incorrectly.

Do you know how I can change all the negative values to positive and vice versa?

Thank you

Corinne

I need to populate a cell with a total from another cell.

If that total from another cell is a negative number I need it to be displayed as a positive number and vice versa, if it is a positive number I need it to be displayed as a negative number.

Example

A1 is ($300)

I need A2 to diplay $300

Thanks for any help with this.

Thank you,

Jay

From the format cells tab, I could not locate a feature that would allow me to convert to an absolute value.

Please provide any hints or advice. Thanks,

1 0.2

-2 0

Assuming the second line is row E, I used =MAX(0,E2/5) to round my negative results to zero. I also want to add to this formula and use it on all of my values so that positive numbers will be rounded up. For example above, assuming the first row is D, I would like the answer to be 1 instead of 0.2 (the result of =MAX(0,D2/5). I want it to be

=ROUNDUP(D2/5,0), which would equal 1.

How can I combine these to work together to round my negative values to zero, but also round my positive numbers up?

Sorry if this is confusing, as I am an excel amateur.

Pete

from negative to positive or vice versa without doing the change cell by

cell? Thanks