Hello, I need help with a formula that can calculate the sum total based on a text in a cell.
-I am addressing the Net Profit column (J).
-Calculate the sum to be positive if Buy/Sell/Win/Lose (column C)) displays a BW or SW.
-Calculate the sum to be a negative if Buy/Sell/Win/Lose displays a...
I've poked around on a bunch of forums for a few days and did a lot of searching around, but most of the results I've found aren't what I'm looking for.
Attempting to take a percentage of a single positive or negative value.
The current formula that I'm using seems to work, but when...