How do I set up formulas with 'if'?

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.

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 [email protected]> 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.

In the cell that currently contains your formula, put:-

=MAX(0,your_formula)

In the cell you want the negative value to go to:-

=MIN(0,your_formula)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"How to use 'IF' in a formula." <How to use 'IF' in a
[email protected]> wrote in message
news:[email protected]...
> 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.