Circular reference in Excel while using the "if" statement

Question

I am trying to use an "if" statement and it goes like this: Cell "1" has an "if" statement which is asking whether cell "2" is less than zero.  If cell "2" IS less than zero, I would like that negative number to be reflected in cell "1".  If cell "2" is greater than zero, I would like cell "1" to display a zero.  How do I do that?  All the formula examples I have found have static "then" actions, like "yes" and "no", etc.  I have not seen anything similar to my issue.

Thanks for any help you can pass along...I'm obviously lost.

Answer 1

Hi,

Note that the logic for your question doesn't say what to do if cell 2 equals zero. This looks at B2 and can go in any cell except B2.

=IF(B2<0,B2,IF(B2>0,0,""))

Answer 2

Thank you!  Worked perfectly!