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.
- How to convert negative numbers to positive numbers Excel
- Instructions to stamp negative numbers in Excel
- Instructions to delete 0, hide 0 in Excel
- 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!
You should read it
- Instructions to stamp negative numbers in Excel
- How to extract numbers or text from Excel
- How to convert negative numbers to positive numbers Excel
- PI (PI Function) in Excel - How to use PI numbers in Excel
- Split numbers from strings in Excel
- Do not round numbers in Excel, turn off rounding in Excel
- Ways to round numbers in Excel
- How to format numbers in Excel
- How to Add Autonumber in Excel
- How to convert numbers into words in Excel?
- How to convert Apple Numbers documents to Microsoft Excel
- SIMPLE way to format negative and positive signs in Excel
May be interested
How to start using Google Docs on mobile devices
How to fix the insert image in Excel
How to add units to cells in Excel
DAYS function, how to use the function to calculate the number of days between two time points in Excel
How to copy formatting in Google Docs, Sheets and Slides
How to create a table border in Word