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.
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.
Thanks. My apologies for any confusion. Here is a copy of the spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AhKaNymiQpM7dG5VSElsRGdyYVQ5ME5XR2pQUW1aX0E
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...