Hi,
I would like a formula so that the new cell returns a positive number for when I have "B" in column G even if I have a negative number for "B".
Likewise when it is "S" I would like the new cell to return a negative number in both cases.
So, in my example s/s: I would like to get the below output:
Desired Result
B 100 100
S -89 -89
S 10 -10
B -5 5
Bookmarks