Excel Formulas using "IF"

[Corey Brock]

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]

Maybe you could use a helper cell with a formula:

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

 

[RagDyer]

See your other post!
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

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