Maybe you could use a helper cell with a formula:

=if(a1="bounced",-b1,b1)



Corey Brock wrote:

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

Regrads,
Corey Brock

--

Dave Peterson