Forum Discussion
Words to function
6 Replies
Cody_Lees You haven't really explained how your data / transactions table looks like, but perhaps the formula shown in the picture below is something you could use. If not, come back here and upload an example of your file (the real structure with some fake data).
Since you tagged your post "Office365", it should work for you. It merely demonstrates a way to interpret a numbers in column C as positives or negatives, based on a word in column B.
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.
