Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bill gras
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rsenn
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bill gras
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert numbers to the opposite sign? CindyatRWD Excel Discussion (Misc queries) 3 October 24th 05 03:24 PM
Convert positive # to negative bgn2 Excel Discussion (Misc queries) 1 September 2nd 05 02:22 AM
how to format numbers stored as text or vice versa to use vlookup teneagle Excel Worksheet Functions 1 February 3rd 05 11:41 PM


All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"