Hi All
wonder if someone could help me
I have 2 columns A&B
In column A i have wording Buy or Sell & in column
B I have values ie 1111 & 2222
I want to put some sort of format in so that if Column A is Sell
it will change the value in column B to a negative and if it is a Buy
it will leave the value as Positive.
wonder if someone could help me
I have 2 columns A&B
In column A i have wording Buy or Sell & in column
B I have values ie 1111 & 2222
I want to put some sort of format in so that if Column A is Sell
it will change the value in column B to a negative and if it is a Buy
it will leave the value as Positive.