Negative Number put in a certain column in a different sheet.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
A2 in Sheet2: =if(Sheet1!A2<0,Sheet1!A2,"")
A3 in Sheet2: =if(Sheet1!A2>0,Sheet1!A2,"")
What about 0?
Stefi
 
You need two formulas, one in A2 and one in A3

=IF(Sheet1!A2<0,Sheet1!A2,"")

in Sheet2 A2, in A3 use

=IF(Sheet1!A2>=0,Sheet1!A2,"")

you can also test for blanks the same way


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

specific data 1
SUM of a 3D calculation 6
Copy non merged to merged cells again 1
Search Entire Sheet instead of 1? 4
Copy non merged to merged cells 2
Copy paste non merged to merged cells 1
if statement, change cell only if true 4
match and display 5

Back
Top