Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 15th 08, 01:55 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 94
Default Remove Negative Signs from Formula Results

Hi All,

Does anyone know how to remove negative signs from formula results? This is
more than just a formatting thing as the figures need to remain positive when
a vlookup draws the data to another sheet and then when the data is imported
into another program.
--
Cheers,
Holly

  #2   Report Post  
Old January 15th 08, 02:04 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 1,091
Default Remove Negative Signs from Formula Results

Multiply by -1? Or use the unary operator to change the sign? If your
formula is =2-3 which produces -1, you can do something like =-(2-3) which
produces 1. It's just elementary algebra.

Tyro

"Holly" wrote in message
...
Hi All,

Does anyone know how to remove negative signs from formula results? This
is
more than just a formatting thing as the figures need to remain positive
when
a vlookup draws the data to another sheet and then when the data is
imported
into another program.
--
Cheers,
Holly



  #3   Report Post  
Old January 15th 08, 03:17 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Remove Negative Signs from Formula Results

Put your formula inside the ABS function:

=ABS(your_formula)

--
Biff
Microsoft Excel MVP


"Holly" wrote in message
...
Hi All,

Does anyone know how to remove negative signs from formula results? This
is
more than just a formatting thing as the figures need to remain positive
when
a vlookup draws the data to another sheet and then when the data is
imported
into another program.
--
Cheers,
Holly



  #4   Report Post  
Old January 15th 08, 03:27 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 94
Default Remove Negative Signs from Formula Results

Thankyou
--
Cheers,
Holly


"T. Valko" wrote:

Put your formula inside the ABS function:

=ABS(your_formula)

--
Biff
Microsoft Excel MVP


"Holly" wrote in message
...
Hi All,

Does anyone know how to remove negative signs from formula results? This
is
more than just a formatting thing as the figures need to remain positive
when
a vlookup draws the data to another sheet and then when the data is
imported
into another program.
--
Cheers,
Holly




  #5   Report Post  
Old January 15th 08, 04:01 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Remove Negative Signs from Formula Results

You're welcome!

--
Biff
Microsoft Excel MVP


"Holly" wrote in message
...
Thankyou
--
Cheers,
Holly


"T. Valko" wrote:

Put your formula inside the ABS function:

=ABS(your_formula)

--
Biff
Microsoft Excel MVP


"Holly" wrote in message
...
Hi All,

Does anyone know how to remove negative signs from formula results?
This
is
more than just a formatting thing as the figures need to remain
positive
when
a vlookup draws the data to another sheet and then when the data is
imported
into another program.
--
Cheers,
Holly








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 to remove multiple @ signs from email? mahesh New Users to Excel 1 October 20th 06 06:03 AM
can I remove negative symbols without a formula PMLACC Excel Discussion (Misc queries) 4 August 25th 06 06:53 PM
What is the formula to display a negative time results? Robluc65 Excel Worksheet Functions 1 October 14th 05 11:15 PM
Negative Results Denise Excel Discussion (Misc queries) 2 October 7th 05 09:17 PM
reversing signs - making postive a negative number mklafert Excel Worksheet Functions 4 November 29th 04 03:18 AM


All times are GMT +1. The time now is 10:08 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017