A2 in Sheet2: =if(Sheet1!A2<0,Sheet1!A2,"")
A3 in Sheet2: =if(Sheet1!A20,Sheet1!A2,"")
What about 0?
Stefi

"naiveprogrammer" wrote:

If in Sheet1 A2 is a negative number put in A2 in Sheet2. If in Sheet1 A2 is
a positive number put in A3 in Sheet2.

How can I do this with a formula???