Formulas cannot place data in another cell.

They can return results only to the cell in which they are written.

The "other" cell must have a formula to check the first cell's value and if
negative, reurn a result.

A1 has a formula that returns a positive or negative result.

In B1 enter =IF(A1<0,A1,"positive") which says if A1 is negative show
result, if A1 is 0 or positive show "positive".


Gord Dibben Excel MVP

On Fri, 11 Feb 2005 13:09:05 -0800, "How to use 'IF' in a formula." <How to
use 'IF' in a wrote:

I am creating a chart that calculates. However, when a calculation comes to
a negative amount, I want that amount automatically placed in another cell.
How do I do this? I know I should type something that includes an 'IF', I
just don't know how to word it exactly.