0

Currently working on making a portfolio tracker.

im looking probably for a if statement that will change my Quantity of shares held to a negative if another column is labeled as 'SELL'. You can see from the image provided, the right column is what im looking for.

enter image description here

Peter
  • 45
  • 7

1 Answers1

1

simple IF switch:

=IF(B2="sell"; GOOGLEFINANCE()*-1; GOOGLEFINANCE())
player0
  • 124,011
  • 12
  • 67
  • 124