Make negative number postive in next cell?

[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

 

[Bob Phillips]

=-A1

etc.

--
---
HTH

Bob

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