Making a Positive Number into Negative 3

[shytott]

Hi
Is there a way to make a positive number into a negative number ie if the value of A1 is 150, how can I make B1 = -150?

Many Thanks

 

[xlbo]

=A1*-1

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Hi,

Multiply the absolute value by -1.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TonyJollans]

Why not just [blue][tt]-A1[/tt][/blue]?

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[shytott]

Thanks Guys
Almost embarrassed I posted that - High School Maths seems a life time ago!!

Much Obliged!