+ Reply to Thread
Results 1 to 2 of 2

Changing value of a cell based on number input in another

  1. #1
    Registered User
    Join Date
    03-09-2015
    Location
    Manchester, England
    MS-Off Ver
    2011 Mac
    Posts
    1

    Changing value of a cell based on number input in another

    Hi,

    I have a spreadsheet where I have the number 1 prepopulated in the cells in column D. I then have values prepopulated in column G.

    What I want to be able to do is, if I change the value of a cell in column D to a 2 for example, I want the cell in column G to change to a hyphen. If the value in column D remains as a 1, I want the value in column G to remain as it is.

    Can any help me with the forumula? I'm assuming it is some kind of IF formula, however, I've tried a few attempts and either get a non valid name or circular reference.

    Thanks

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Changing value of a cell based on number input in another

    You can only do that using VBA.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sheet Change Event Dubuggin: Restrict Cell Values toand Changing cells based on input
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-28-2013, 02:37 PM
  2. [SOLVED] Changing copy range based on cell input.
    By randomguy1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2013, 08:59 PM
  3. [SOLVED] Changing the cell colour based on what is input in another cell.
    By MissMay in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-21-2013, 10:21 AM
  4. Changing text in cell based on input of another cell
    By 1grimmgirl in forum Excel General
    Replies: 1
    Last Post: 01-23-2011, 10:41 AM
  5. New to excel, having trouble changing values based on an input cell
    By MyUserName in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-18-2006, 10:20 PM

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