Make negative number postive in next cell?

  • Thread starter Thread starter Kirstie Adam
  • Start date Start date
K

Kirstie Adam

Hi,

I have one cell, which is the result of a calculation between 2 figures, and
the cell next to it needs to be the same number - but the direct opposite.

eg.

if the result of the calculation is -47000, the cell next to it needs to be
47000
if the result is 2000, the next cell needs to be -2000

Can anyone tell me how to do this?

Thanks,

Kirstie
 
=-A1

etc.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top