Hello,

I am trying to make one cell automatically change to a negative number based on the text in another cell.

For example:

If Cell B4 contains "W" for withdrawal, then I would like C4 to automatically be a negative number.
So B4 = "W" then C4 ="-$100.00"

Thank you!