Changing one cell based on the value of another cell

[caitie]

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!

[tony h]

There are various options but try this example:

A1 =100 A2=W A4 = =if(A2="W", a1*-1,a1)

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.