Excel - Remove Negative Signs from Formula Results

Asked By Holl on 14-Jan-08 08:55 PM
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




Tyro replied on 14-Jan-08 09:04 PM
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 is just elementary algebra.

Tyro
T. Valko replied on 14-Jan-08 10:17 PM
Put your formula inside the ABS function:

=ABS(your_formula)

--
Biff
Microsoft Excel MVP
Holl replied on 14-Jan-08 10:27 PM
Thankyou
--
Cheers,
Holly
T. Valko replied on 14-Jan-08 11:01 PM
You're welcome!

--
Biff
Microsoft Excel MVP