in a column I have rows of outcomes that are positive and negative numbers

in the two following columns, one is only for numbers > or = 0, and the second one is only for negative numbers.

=IF($E8>=0,$E8,"")

=IF($E8<0,"",$E8)

however regardless if it's true or false it is posting the number.

help pls

Positive column
=If(e8>=0,e8,"")

Negative column
=If(e8<0,e8,"")

You just derped a bit on the last formula
Lmk if u need help with anything else!
You don't need a $ if you're dragging the formula down rows

This post was edited by Penguins0690 on Apr 26 2017 05:14pm

can also do iferror instead of if

also, why don't you put a filter on the column and sort from smallest to largest?

This post was edited by Penguins0690 on Apr 26 2017 06:11pm