Anderson620
New member
- Joined
- Mar 14, 2013
- Messages
- 3
- Reaction score
- 0
- Points
- 0
I'm fairly new to Excel aside from basic stuff and have been trying to find the answer to this for days now. (I'm on my phone so I can't upload the file) I have 2 columns; A:A will be the category I assign to expenses and B:B is the actual expense description. B1 shows "deposit" and B2 shows "Paycheck number xxx-xxxx" with the X's representing weekly changing numbers. I would like a formula along the lines of =if (b:b="income" (or) "paycheck", "income", "")
It seems that the (or) is the part Im having trouble with. The first cell (B1 showing Deposit) fills A1 with Income but the next row does nothing. Also if I put the Paycheck description first it gives a "False" because it seems to be looking for the entore cell contents, which change with each entry. Theart that is common is they all will say PAYCHECK. I've heard that it is possible to create available table on another sheet and just reference it, but at this point finding the right formula is personal. I can't let it win! Any help would be greatly appreciated.
It seems that the (or) is the part Im having trouble with. The first cell (B1 showing Deposit) fills A1 with Income but the next row does nothing. Also if I put the Paycheck description first it gives a "False" because it seems to be looking for the entore cell contents, which change with each entry. Theart that is common is they all will say PAYCHECK. I've heard that it is possible to create available table on another sheet and just reference it, but at this point finding the right formula is personal. I can't let it win! Any help would be greatly appreciated.