Make negative number postive in next cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kirstie Adam - 16 Aug 2007 09:38 GMT

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

Reply to this Message

Bob Phillips - 16 Aug 2007 09:43 GMT

=-A1

etc.

Signature

---
HTH

Bob

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

> Hi,
>
[quoted text clipped - 13 lines]
>
> Kirstie

Reply to this Message