| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
Separate Positive And Negative Numbers With Formula In Excel
Separate positive numbers from the list first. Select a blank cell and type this formula =IF($A1=0,$A1,"") (A1 is the cell in your list), press Enter button and drag fill handle to fill range you want, you can see only positive values are separated into the column. Then type this formula =IF($A1<0,$A1,"") into another column cell, and press Enter button, and drag fill handle to fill range you want. Now you can see the positive and negative values are separated into two columns. I hope this is helpful! Admin O365CloudExperts |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summing only positive or negative values | Excel Worksheet Functions | |||
| Changing positive values to negative | New Users to Excel | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| ... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
| switching values from positive to negative | Excel Worksheet Functions | |||
Threaded Mode
