Results 1 to 6 of 6

Thread: A1 change into C1 only if E1 is True.

  1. #1
    Neophyte spiceytayley's Avatar
    Join Date
    May 2019
    Posts
    4
    Articles
    0
    Excel Version
    Microsoft Excel 2010

    A1 change into C1 only if E1 is True.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello. I'm trying to create a formula in excel that will make A1 change into C1 only if E1 is True.
    If E1 is false, I need the cell in A1 to remain as is.
    (I'm trying to get this to happen without adding another column with the same values as originally located in column A).
    Any assistance would be greatly appreciated.
    Thank You <3

    U 77 B 2402 TRUE
    EX: The above "U" should change into the "B" because it is marked as "TRUE"

    B 72 C 2264 FALSE
    EX: The above "B" should remain the same ("B") as it is marked "FALSE".

    This is the data that I'm working with:
    B 12 B 216 FALSE
    B 13 B 308 TRUE
    B 14 B 434 FALSE
    B 38 B 1061 TRUE
    M 39 B 1126 FALSE
    U 77 B 2402 TRUE
    B 78 B 2414 FALSE
    B 118 B 3477 FALSE
    U 119 B 3492 TRUE
    B 124 B 3631 FALSE
    U 151 B 4483 TRUE
    M 152 B 4515 FALSE
    M 162 B 4769 FALSE
    U 163 B 4784 TRUE
    B 164 B 4825 FALSE

  2. #2
    Acolyte Heyjoe's Avatar
    Join Date
    Jan 2019
    Location
    USA
    Posts
    55
    Articles
    0
    Excel Version
    2019
    Spiceytaley
    A few questions
    1) Is the reason you don't want to add a column because you don't want to change how your worksheet looks? If so you could have a data entry column where you enter the values that you have in column A, then you could hide it easily hide it using the group command under the data menu. You could then enter formulas in Column A that reference you data entry column.
    2) Another option would be to enter all of your data that you show in workbook 1. Then have formulas in worksheet 2 that will change the what is in column A.
    3) Another option would be a code solution.

    Would any of this 3 solutions work for you?

  3. #3
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,682
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Please post a sample sheet so we can work with it
    Click Go advanced - Manage attachments and follow the wizard. Thanks
    Thank you Ken for this secure forum.

  4. #4
    Neophyte spiceytayley's Avatar
    Join Date
    May 2019
    Posts
    4
    Articles
    0
    Excel Version
    Microsoft Excel 2010
    Maybe a code solution?
    We are just trying to make it happen without adding extra data to the mix.
    I've attached a sheet.Formula Inquiry.xlsx

  5. #5
    Acolyte Heyjoe's Avatar
    Join Date
    Jan 2019
    Location
    USA
    Posts
    55
    Articles
    0
    Excel Version
    2019
    Quote Originally Posted by spiceytayley View Post
    Maybe a code solution?
    We are just trying to make it happen without adding extra data to the mix.
    I've attached a sheet.Formula Inquiry.xlsx
    Code:
    Public Sub mysub()
    Sheets("sheet1").Select
    Dim rng As Range, cell As Range
    
    
    Set rng = Range("a1:a200")
    
    
    For Each cell In rng
        If cell.Offset(0, 4).Value = True Then
        cell.Value = cell.Offset(0, 2).Value
        End If
    Next
    
    
    End Sub

  6. #6
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,682
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Please don't quote whole posts -- it's just clutter and makes the thread hard to read. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
    For normal conversational replies, try using the QUICK REPLY box below.
    Thank you Ken for this secure forum.

Tags for this Thread

Posting Permissions

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