=IF(A1="bounced",-500,500)

or if the 500 is from another cell

=IF(A1="bounced",-H5,H5)

The formula has to be in the cell that is to change.

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

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

"Corey Brock" wrote in message
...
If I enter the word "bounced" in one cell can I trigger a
value in another cell ($500.00) to become a negative
number (-$500.00)?

Regrads,
Corey Brock