Sorting out negative numbers
 

I have numbers in column A like this
A B C
-60.0 -60
-60.9 -60.9
55.0 55
-63.7 -63.7
25.0 25
-71.0 -71
35.0 35
I need to sort out only negative numbers in column C and Positve numbers to
Column B using some formula or function, can anyone help me in this i will be
really grateful. Thanks

Sorting out negative numbers
 

Assuming that the first value (-120) is in cell A2.

Insert following formula in B2:-
=IF(A2=0,A2,"")

Insert following formula in C2:-
=IF(A2<0,A2,"")

Copy the formulas down.

Note: The first formula will include zero as a positive.

--
Regards,

OssieMac


"srpavar" wrote:

I have numbers in column A like this
A B C
-60.0 -60
-60.9 -60.9
55.0 55
-63.7 -63.7
25.0 25
-71.0 -71
35.0 35
I need to sort out only negative numbers in column C and Positve numbers to
Column B using some formula or function, can anyone help me in this i will be
really grateful. Thanks

Sorting out negative numbers
 

On Jul 21, 12:59 am, OssieMac
wrote:
Assuming that the first value (-120) is in cell A2.

Insert following formula in B2:-
=IF(A2=0,A2,"")

Insert following formula in C2:-
=IF(A2<0,A2,"")


I might add:
If B and C are accounting columns, you won't want the minus sign
showing in Col C. So change that formula to: =IF(A2<0,ABS(A2),"")