How To Split Columns to Seprated Negative and Positive Values in Excel
This post will guide you how to separate negative numbers and positive numbers from a column into two columns with a formula in Excel. How do I split numbers into two columns with negative and positive numbers in Excel.
Splitting Columns to Separated Positive and Negative Numbers
Assuming that you have a list of data in which contain positive and negative numbers in column A in your worksheet, and you want to separate your data into two columns. and you want to column B to list all positive nubmers from column A, and column C to show all negative numbers from column A. How to do it. and you need to use two formula based on the IF function. see below:
Extracting all Positive numbers:
=IF($A1>=0,$A1,"")
You need to type this formula into Cell B1, and press Enter
key on your keyboard, and then drag the AutoFill Handle down to other cells.
Extracting All Negative Numbers:
=IF($A1<0,$A1,"")
You need to type this formula into Cell C1, and press Enter
key on your keyboard, and then drag the AutoFill Handle down to other cells.
Related Functions
- Excel IF function
The Excel IF function perform a logical test to return one value if the condition is TRUE and return another value if the condition is FALSE. The IF function is a build-in function in Microsoft Excel and it is categorized as a Logical Function.The syntax of the IF function is as below:= IF (condition, [true_value], [false_value])….
Comments
So empty here ... leave a comment!