If statement

[adamant06]

Cell A1 determines the value in cell A2; if A1 = 1, A2 = 10; if A1 = 2, A2 = 100

I want cell B1 to equal A2 as if A1 = 1, regardless of what A1 actually equals. So for instance, if A1 = 2, I want B1 to equal what A2 would equal if A1 = 1; in this case, B1 should equal 10, even though A2 = 100. In essence, I am trying to run the spreadsheet within the cell independently.

How do I write a function within B1 to acheive this, preferably without VBA?

Thanks so much.

[adamant06]

the actual problem i am having is far more complex; I have simplified the situation, so the solution I am looking for is independent of the values I have chosen for these cells.

This is probably obvious, but just thought I would clarify just in case.

[arthurbr]

Hi
could you paste an example of what you want to achieve and of your data.

Thx

[adamant06]

Starting with:
A1 = 2
A2 = IF(A1=1, 10, 100)

What I want:
B2 = whatever A2 would equal if A1 = 1
in this case, B2 = 10