Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to remove multiple @ signs from email? | New Users to Excel | |||
can I remove negative symbols without a formula | Excel Discussion (Misc queries) | |||
What is the formula to display a negative time results? | Excel Worksheet Functions | |||
Negative Results | Excel Discussion (Misc queries) | |||
reversing signs - making postive a negative number | Excel Worksheet Functions |