Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert negative numbers to positive numbers and vice versa
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert negative numbers to positive numbers and vice versa
multiply by minus one. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=491306 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert negative numbers to positive numbers and vice versa
Easiest way is to change the formula:
=abs(vlookup(d53,an54:ao2000,2,false)). If you want to negate a range of cells, you can also type a -1 in some random cell, copy it, select your range then Edit Paste Special, select Multiply and click OK. "bill gras" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert negative numbers to positive numbers and vice versa
If, as your subject says, you want to convert negative to positive, and vice
versa, simply put a minus sign in front of your formula, as in: =-VLOOKUP(D53,AN54:AO4000,2,FALSE) If, as the body of your message says, you want to convert negative to positive, but leave the positive results as is, use: =ABS(VLOOKUP(D53,AN54:AO4000,2,FALSE)) -- Regards, Fred "bill gras" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert negative numbers to positive numbers and vice versa
Hi Fred , rsenn , bpeltzer
Thank you all for your reply Just what I was looking for , once again , thanks! regards bill -- bill gras "Fred Smith" wrote: If, as your subject says, you want to convert negative to positive, and vice versa, simply put a minus sign in front of your formula, as in: =-VLOOKUP(D53,AN54:AO4000,2,FALSE) If, as the body of your message says, you want to convert negative to positive, but leave the positive results as is, use: =ABS(VLOOKUP(D53,AN54:AO4000,2,FALSE)) -- Regards, Fred "bill gras" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert numbers to the opposite sign? | Excel Discussion (Misc queries) | |||
Convert positive # to negative | Excel Discussion (Misc queries) | |||
how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions |