MS Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does any one know the formula for converting positive figures to Negatives
 
=if(a1>0,-a1,a1)

or ...

=-abs(a1)

==========
If you're careful, you can do this without formulas.
Put -1 in an empty cell
copy that cell
select your cells to change (click on the first and ctrl-click on subsequent)
edit|paste special|check multiply

Clean up that helper cell with -1 in it.
 
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

How do I calculate variance percetage if figures are negative 5
Trying to reconcile a column 1
Help with positive and negative numbers 1
Need help with frequency formula 2
Cause formulae totals to reflect negative and positive amount inpu 7
negative fractions 3
Flipping numeric values 3
Maximum negative number 1

Back
Top