Related:
- Checking for multiple words (text) in a cell
- How to make multiple selections in photoshop - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Check back here for the result. - Facebook Forum
2 responses
I'm not sure if this is exactly what you're looking for, but I use excel to balance my checkbook and I created this formula to categorize each of the transactions so that I can track my spending better. The formula has three categories: Drinks, Restaurants, and Fuel. in this example the formula is looking at cell N69 and it searches for multiple key words or phrases to determine which category the transaction goes in.
=IF(ISERR(SEARCH("coke",N69)),IF(ISERR(SEARCH("gas",N69)),IF(ISERR(SEARCH("wendy's",N69)),NA(), "restaurants"),"fuel"),"Snacks")
In N69 I typed "Walmart- coke & chips - $3", so M69 displays "Snacks"
If i had typed "Chevron - Gas" M69 would display "Fuel"
to add another category or extra key word you want to find, insert
"IF(ISERR(SEARCH("chips",N69)),NA(), "Snacks")" where "NA()" is.
Hope it helps.
=IF(ISERR(SEARCH("coke",N69)),IF(ISERR(SEARCH("gas",N69)),IF(ISERR(SEARCH("wendy's",N69)),NA(), "restaurants"),"fuel"),"Snacks")
In N69 I typed "Walmart- coke & chips - $3", so M69 displays "Snacks"
If i had typed "Chevron - Gas" M69 would display "Fuel"
to add another category or extra key word you want to find, insert
"IF(ISERR(SEARCH("chips",N69)),NA(), "Snacks")" where "NA()" is.
Hope it helps.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 9, 2010 at 05:03 PM
Jul 9, 2010 at 05:03 PM
how many words are we talking about here
