+ Reply to Thread
Results 1 to 3 of 3

Change cell values depending on other cell's values

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Change cell values depending on other cell's values

    Hi guys,

    If I have a cell (A2) which says, yes, can someone help me write an IF function to input 'No' in B2 and C2?

    Similarly, if B2, has yes, A2 and C2 should say no

    If C2 says yes, A2 and B2 should say no.

    Thanks,

    R.
    Thanks,

    R.



  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Change cell values depending on other cell's values

    I am afraid that generate circular references.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Change cell values depending on other cell's values

    There is circular reference warning.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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. Change cell values from tt:mm to comma number, depending of a cell value
    By gnaske in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-12-2018, 08:29 AM
  2. [SOLVED] change value of a cell depending on multiple cell values
    By Doido in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2016, 02:29 PM
  3. [SOLVED] Change Row & Cell Colours Depending Upon Certain Values
    By jaredino in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-18-2016, 11:22 AM
  4. [SOLVED] Inserting Values in a Cell Depending on Content in an Adjacent Cell
    By lowlybroker in forum Excel General
    Replies: 3
    Last Post: 03-20-2014, 01:23 PM
  5. Change cell value within a row depending on other cell values within same row
    By cameron213 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2013, 05:34 PM
  6. Replies: 8
    Last Post: 08-25-2012, 04:27 AM
  7. Replies: 8
    Last Post: 05-19-2005, 07:06 PM

Tags for this Thread

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