+ Reply to Thread
Results 1 to 3 of 3

how to write rules or formulas to read text is cell A1 and list different text in A2?

  1. #1
    Registered User
    Join Date
    12-30-2011
    Location
    United STates
    MS-Off Ver
    Excel 2010
    Posts
    1

    how to write rules or formulas to read text is cell A1 and list different text in A2?

    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

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: how to write rules or formulas to read text is cell A1 and list different text in

    Maybe this:

    =IF(OR(A1={"ATW","CW Feed","xyz"}), "Farm","")

  3. #3
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: how to write rules or formulas to read text is cell A1 and list different text in

    Or is this... as you said 'certain words'

    =IF(COUNT(SEARCH({"ATW","CW Feed","xyz"},A1)),"Farm","")
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1