Need formula to negate

[Julie P.]

Hi, does anyone know if there is an Excel formula which returns the opposite
number of a given number?

For example, if I have $1.45, how can I make it -$1.45 or ($1.45)?

I tried a made up formula of mine:

=NEG(A5)

but it didn't work.

Thanks!

 

[Norman Harker]

Hi Julie!

Try:

-A5

If A5 is positive, this will make it negative.
If A5 is negative, this will make it positive.

 

[Julie P.]

Hi Julie!

Try:

-A5

If A5 is positive, this will make it negative.
If A5 is negative, this will make it positive.

Wow, what a fast answer! Thanks so much Norman. It worked perfectly!

J.