Remove Negative Signs from Formula Results

  • Thread starter Thread starter Holly
  • Start date Start date
H

Holly

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If sign of sum is negative change to positive 1
Negative numbers in resulting formula 2
Subtracting positive amts from negative and positive from positive 3
How do I limit formula results to positive only? 4
Negative number format 5
How to change numbers from positive to negative. 2
Ending Negative Sign 4
Rounding Negative Numbers to Zero 4

Back
Top