Hi.
What I want the operator to do is input a value in a cell (let's say cell A1) and depending on what is entered by the operator the value of another cell (lets say A9) will vary.
So the operator is going to enter into cell A1 either A,B,C,D or E. If A is entered then I want the value of cell A9 to be 10. If B is entered then I want the value to be 20. If C is entered then I want the value to be 30. If D is entered I want the value to be 40. If D is entered I want the value to be 50.
Basically what I want to say is If A1=A then A9=10. If A1=B then A9=20. If A1=C then A9=30. If A1=D then A9=40. If A1=E then A9=50.
What would be the correct syntax for this formula? And how would I prevent the operator from entering anything other than A,B,C,D or E?
If some one can answer this question it would be greatly appreciated.
Bookmarks