Negative Numbers & IF Formulas

[SammySpaceman]

I have three cells. In cell 1, I will be putting a number. If the number is negative, I want it copied to cell 2. If the number is positive, I want it copied to cell 3. How can I do this?

 

[lenze]

How about in Cell 2 enter

=IF(Cell 1>0,Cell 1,"")

For Cell 3 enter

=IF(Cell 1 <0,Cell 1,"")

What about zero?

Also, you could write a Change Event to do this by code. Repost if you need help.

 

[SammySpaceman]

I'm actually not concerned about zero. So your method works great. Thanks a lot!