How to separate negative and positive numbers in Excel

Excel functions are always an indispensable tool when we process data tables. Each Excel function will apply to many different cases. For example, with the exercise of finding negative numbers and positive numbers in the same Excel data table, we will use the IF function. Instead of having to sit for each number, with IF function, we will find the negative and positive numbers quickly, easily manage them. The following article will show you how to separate positive and negative numbers in Excel.

1. How to convert negative numbers to positive numbers Excel
2. Instructions to stamp negative numbers in Excel
3. Instructions to delete 0, hide 0 in Excel
4. How to convert money into words in Excel

How to use the IF function to find positive numbers and negative numbers

We will deal with the following table with no positive and negative numbers.

How to separate negative and positive numbers in Excel Picture 1

Step 1:

To find a positive number, the user will have the formula = IF ($ number needed to calculate> = 0; $ number to count; return the selected expression) .

Applying to this data you enter the formula = IF ($ B1> = 0; $ B2; '') and then press Enter to execute the IF function.

How to separate negative and positive numbers in Excel Picture 2

Step 2:

The result will be the first positive number for the column.

How to separate negative and positive numbers in Excel Picture 3

Drag the positive number box to the rest of the column. Then in positive Number column will display positive numerical values ​​in accordance with the function syntax implemented.

How to separate negative and positive numbers in Excel Picture 4

Step 3:

Next switch to a negative number column to find values ​​that are negative numbers . To find the negative number in the user table, use the first cell of the user column to enter the formula = IF ($ number needs to count <0; $ number to calculate; returns the selected expression) .

Apply to the table and enter the formula = IF ($ B2 <0; $ B2; '') and press Enter.

How to separate negative and positive numbers in Excel Picture 5

Step 4:

Since the consultation box does not satisfy the condition, the results will not be displayed. We drag the first cell down the remaining cells. The column results will display negative values ​​based on the data table.

How to separate negative and positive numbers in Excel Picture 6

Thus, the positive and negative values ​​are separated by using the IF function in Excel. The function will find the exact negative and positive numbers and then return the results to you. But the cell does not match the value to be found.

I wish you all success!