I have some transaction data with in and out entries, ie. “Buy” and “Sell”, but they are all listed in positive figures except for a separate column that states Buy or Sell.
I’ve been at this for 4 hours now and I can’t figure out a formula that takes the entry amount and turns it into a negative if it’s labeled as sell. I’ve tried converting the textstrings to numbers, giving them boolean values etc, my logic steps are depleted.
I’d like to keep the data intact, if possible.
Please for the sake of my sanity, help.
2021-05-11 Potato BUY 5.21 €13.51 2021-05-11 Potato SELL 4.10 €12.11
[Edit - Opaque] Put Example data to preformatted text
Edit: Solved, my mistake was that I tried adding the function directly to the original cell, and so making it reference itself, giving the error 522. I guess this is a rookie error, but I thank you for getting me on the right track to solve it!