Thread: HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
  
Posts: 698
Default HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN
For the negative numbers in column B.

=IF(LEFT(A1,1)="-",A1,"")

And the positive numbers in column C.

=IF(LEFT(A1,1)="-","",A1)

You may want to Select Copy Edit Paste special Values OK. Returns
the results to numbers instead of formulas.

HTH
Regards,
Howard

"FRANK" wrote in message
...
I HAVE A COLUMN OF FIGURES I WISH TO MAKE TWO MORE COLUMNS ONE SHOWING
POSITIVE VALUES ONE SHOWING NEGATIVE VALUES


Reply With QuoteReply With Quote