Sepatate positive and negative numbers

  • Thread starter Thread starter Joe Soap
  • Start date Start date
J

Joe Soap

Hello

Is it possible to automatically separate positive and negative numbers
(precedeed by a minus sign) from one column into two different columns ?

I'm using Excel 97.

Thank you

Joe
 
If you have your list of numbers in Col A starting in Row 1
Put this formula in B1 =if(A1>0,A1,"") for pos #'s
Put this formula in C1 =if(A1<0,A1,"") for neg #'s

Copy the two formulae down as far as needed
Note that zero will not show in either col B or
 
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

Excel column sum of negative and postive numbers. 1
Turning negative to positive on a mass scale 3
Excel VBA to match positive and negative transactions 3
Forumala issue 0
counting negative and positive percentages in a column 2
How to format negative currency as red with a negative sign? 4
How to ignore negative numbers 3
Array formula difficulty 10

Back
Top