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
wrote in message
...
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.