Forum Discussion
Words to function
Here is the test data. Would I have to make a different column for the equation or could I over lay the function to transaction Colum with out taking out the words?
Cody_Lees You uploaded a picture, not a file. What do you mean by "could I over lay the function to transaction column with out taking out the words?"
You original question was "how to take a cell with a word and make that word in the cell an action?". Not really sure what you want.
Sorry this is a bit new for me. Ok! So im trying to take data of present and future transactions that will come from a stock brokerage in this format that is attached. I want to figure out what my book value is and how many shares I have currently but the info comes in a word format buy and sell not plus and minus... also dividend and reinvested. So if I could take the word and give it a corresponding action to a different cell in the quantity column then I could figure out the total shares held.
Cody_Lees Thanks for this. The plus/minus seems to be in the Amount column, so what is it that you want to calculate? All the Buy and Reinvest amounts are negative. All others are zero or positive.
- Do you have an email I can send you the full sheet to get a better understanding?