I am working on a spreadsheet for our finances with different entries. I am working on setting up rules or a long formula to help me out, I want it to read the transaction and if it has certain workds than in another cell list it as an account. . I want it to read the test in A1 (if it says "ATW" or "CW Feed" or "xyz" than enter "Farm" in A2. I hope thatt his makes since. Any help is appriciated.
Thanks
Maybe this:
=IF(OR(A1={"ATW","CW Feed","xyz"}), "Farm","")
"Relax. What is mind? No matter. What is matter? Never mind!"
Or is this... as you said 'certain words'
=IF(COUNT(SEARCH({"ATW","CW Feed","xyz"},A1)),"Farm","")
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks