if negative then goes in collum b

Hi, I need something that will automatically place negative numbers in a certian collum. Is there anyway to do this. Heres an example. collum 1 is for positive numbers, and if one is negative then i need it to be placed in collum 2 which is for negative numbers. Hmm... Thanks for any help with this

If you have a column of mixed numbers, then to separate them use these formulae:

negatives =min(yourcell,0)
positives =max(yourcell,0)

If you don't want to see the 0's that result, go to Tools, Options, and untick the zeroes box.

Regards