Need formula to negate

  • Thread starter Thread starter Julie P.
  • Start date Start date
J

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!
 
Hi Julie!

Try:

-A5

If A5 is positive, this will make it negative.
If A5 is negative, this will make it positive.
 
Norman Harker said:
Hi Julie!

Try:

-A5

If A5 is positive, this will make it negative.
If A5 is negative, this will make it positive.
Click to expand...

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

J.
 
Back
Top