• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF logic that replicates the value of two other cells in response to a trigger

M

mmexcel

New Member
Hello -


I am trying to construct a logical statement based on a trigger. The trigger is based on a Yes or No. We can call this column A in row 5. Rows 1 through 4 are NOs. In columns B and C I have a range of number values. I would like to write a statement that when a Yes is triggered the cells in rows 3 and 4 (Column B) equal rows 3 and 4 in Column C. Otherwise, they will remain the same. Please advise.
 
Mmexcel


Firstly, Welcome to the Chandoo.org forums.


I am a bit unclear as to your exact requirement


You can use the If() function to enable decisions

In your case in C3 I think you want:
Code: 
=IF(A5="Yes",C3,A3)


Please read teh 3 Sticky Green posts on the main forum page

They give useful info on how best to get help here

Posting a sample file with some example data is a great way to get more accurate help

You can post a sample file, Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Thanks. My apologies for any confusion. Here is a copy of the spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AhKaNymiQpM7dG5VSElsRGdyYVQ5ME5XR2pQUW1aX0E
 
The goal is to create a statement in column D. If a Yes is triggered then D3 and D4 will equal the values in C3 and C4. Otherwise, the values in D will equal the values in B, which is the case for D1 and D2. I hope this is more clear.
 
Mmexcel


You need to give Google docs public access for us to access them
 
Hi, mmexcel!

I still have doubts, perhaps you might clarify them:

- trigger is only valid in row N and operates on cells of columns B:C of rows N-2 and N-1?

- if so, what about a YES in cell A1?

- if not and a YES in A6, what should be done?

Regards!
 
Hello - Column A is the trigger. A Yes in column A indicates that the values in D3 and D4 are equal to C3 and C4. Otherwise, the value is D is equal to B.
 
Mmexcel

I'd suggest using another column to help

In D1: =IF(A1="YES",C1,B1)
 
Hi, mmexcel!

Still confused but it must be my fault. Try with Hui's suggestion and if it's not what you wanted, please come back and elaborate it a bit more. Thank you.

Regards!
 
You must log in or register to reply here.
Back
Top