Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Lets say that I have 3 parameters/cells:

  • High (Cell A1)
  • Medium (Cell A2)
  • Low (Cell A3)

the fixed values for these cells are 2, 2 ,2

how can I change the value of cellA1 based on the changes of cellA2, or cellA3. for example: if cellA2 value is 1, I have to add 1 to cellA1, and if its Zero I have to add 2 to ceelA1.

can you help please?

share|improve this question

migrated from stackoverflow.com Dec 26 '12 at 17:32

This question came from our site for professional and enthusiast programmers.

1  
Simple changes can be tracked like this. in cell A2 put this =A1+1 Its possible to put complicated ones as well –  Naresh Dec 24 '12 at 11:13
1  
@Naresh : I would -1 that comment if I could. OP asks for conditional logic. Your formula breaks on his second case (if it's zero). –  Alexandre P. Levasseur Dec 24 '12 at 14:01
1  
@toti You need to tell us a bit more. How many conditions or statuses are there ? Is it only cell A1 that you will modify and expect the other cells to follow ? What should happen if the value entered is something else than 0 or 1 ? –  Alexandre P. Levasseur Dec 24 '12 at 14:02

1 Answer 1

You could do it this way:

The A cells have formula's & you would enter values in the B cells. Based upon the formulas below is B2 way 2 then A2 would be 2 & A1 would be 2. If B2 was 1 then A2 would be 1 & A3 would be 3.

A1 formula: =(2-A2)+B1
A2 formula: =B2
A3 formula: =B3
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.