Changing variables for calculating a result

[WS6FirebirdTA00]

I tried to search for this with no success. I know it is on here somewhere as I first saw it here.

Lets say I have data in A1, A2, A3, A4, and A5. What I want to do is create a drop down where you select the value you want to calculate, it highlights the cells you need to enter data in, and calculates the result for the selected cell.

Just to use some numbers, let's just say that A1+A2+A3-A4=A5. The real formula will be much more complex than this, I am just trying to keep it simple. I select that I want to calculate A2 in the drop down (which results in a formula of A2=A5-A1-A3+A4), it highlights A1, A3, A4, and A5. I then enter values in those cells and the result is calculated in A2. Then the next time around, someone using this sheet may want to do the same thing but they have all the values except for A3.

Make sense? Can anyone point me in the right direction?

Thanks.

[Ruthki]

I think you may be looking for the goal seek tool which can be found on the tools menu.

R

[shg]

Maybe something like this is what you had in mind?

[WS6FirebirdTA00]

Thanks, I will check it out.

[WS6FirebirdTA00]

Yes, similar to that. I will try to go through it and see how it works out. Thanks!