What if there is already a formula in that cell that needs
to be changed. In this case G39 is "=SUM(G25:G38" and I
need D25 though D28 to have the option for the "bounced
text.
For Example: If D25 is "bounced", then the value in G25
should become a negative number which will make the
adjustment on the total for G39

Corey

-----Original Message-----
=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



.