Associate positve / negative value according to a given name in a cell

Hello, how's going people? I'm having a hard time to figure out something that may be extremely simple but I just can't see the answer. I've tried to attach a file with an example but somhow I couldn't, so I'll upload an image instead:

Example.png

I have this list of Incomes / Expenses to manage in a cash flow. Needless to say that incomes mean positive and expenses is simply negative. What I want to know is if there's a way to associate the name of a given cell to a negative value. Like, for instance, I have this "income (products)" value of 500 in a single column (instead of two to separate positives and negatives). Just by using that name, Excel automatically understands that the "Position" column should display a positive value instead of a negative one.

Thanks in advance,


Zenarte

Thank you for the information, I shall give it a try ~


Zenarte

Never mind folks, I think I've got it! Here's my solution

Please Login or Register  to view this content.