changing sign

  • Thread starter Thread starter simora
  • Start date Start date
S

simora

How do I change a value using either a formula or Macro
etc.. so that positive values become negative values when
sent to another cell for calculations
 
If you have 100 in A1 and you want -100 in B1 try

=-A1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif 8
if format problem 9
If sign of sum is negative change to positive 1
How do I limit formula results to positive only? 4
Scrabble Value calculation for Welsh words 0
Need Help with "SUM" AND "ABS" in same formula 12
how can I pick up a nearest value to zero 3
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10

Back
Top