| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 | |||
Hybrid Mode
