+ Reply to Thread
Results 1 to 4 of 4

Cell Value causes a small change inside another cell

  1. #1
    Forum Contributor
    Join Date
    03-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2011
    Posts
    474

    Cell Value causes a small change inside another cell

    Hello,

    for example...
    if the word "happy" is in column B, I would like the cells in column A to display what theyre already displaying but add "(H)" to the end of the value.
    so in A1 the value is "apple (H)" because "apple" was already in A1 and "Happy" in cell B1 causes the addition of "(H)".

    hope that makes sense.

    thanks

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,111

    Re: Cell Value causes a small change inside another cell

    =IF( B2= "Happy", A2&"H","what to put if not happy")

  3. #3
    Forum Contributor
    Join Date
    03-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2011
    Posts
    474

    Re: Cell Value causes a small change inside another cell

    where would i put that? dont forget the cell value for column A is still Apple, Banana, Orange etc.
    how can i put this formula in as well as the original values?

    thanks

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,111

    Re: Cell Value causes a small change inside another cell

    you would need someone to provide some VBA for that

+ 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