Put into B2:
=if(A2<0,A2,"")

Copy down as far as you need. You can use a formula in one cell to
clear the contents of another cell.

However, I think you could use custom formatting to hide negative
values in column A.

Muppet Man


On Sep 26, 9:13*pm, Sojo wrote:
I am writing a macro to automate several processes. *I have the following
table where column A has positive and negative values and column B is blank. *
I need a formula that will find all the negative values in column A and move
them to column B. *In essence, it needs to say if number in column A < 0,
then cut it and paste it into column B.

* * * * *A * * * * * * * * *B
1. * Original * * Negative
2. * 3.72545 * *
3. * 3.4584 * *
4. * *3.1071 * *
5. -0.460399 * *
6. -0.803222 * *
7. -1.12457 * *