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

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

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

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

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