Make value negative based on symbol in row

[joacro]

Hi there,

I have two columns In the one column is a symbol and in the other an amount if the symbol in D = P then the amount in Column E should be negative.

I then have a total box that will add and subtract the value's together. How do I insert a line automatically when I want to make a new entry

Hope anyone will be able to assit

Regards

 

[Zack Barresse]

Not sure where you data resides specifically, but perhaps:

=E1*IF(D1="P",-1,1)

Then you can sum the values normally.