Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Negative Number put in a certain column in a different sheet.
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??? |
#2
|
|||
|
|||
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??? |
#3
|
|||
|
|||
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 "naiveprogrammer" wrote in message ... 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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
How do I sort a column a unique number? | Excel Worksheet Functions | |||
How do I enter a negative number in unit price column? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |