X IN A CELL TO CALCULATE A FORMULA

I WANT TO PUT AN X IN A CELL TO CALCULATE A FORMULA. I HAVE 2 BOXES, AND I
NEED TO PUT AN X IN ONE OR THE OTHER TO CALCULATE 2 DIFFERENT FORMULAS. IF I
PUT AN X IN ON CELL I DON'T WANT THE OTHER CELL TO TAKE ACTION. ANY
SUGGESTIONS

Hi,

2 alternatives:
A2: =IF(B2="X",Formula 1,"")
A3: =IF(B3="X",Formula 2,"")
or
A2: =IF(B2="X",Formula 1, Formula 2)
or
A2: =CHOOSE(B2,Formula 1,Formula 2)
where B2=1 or 2

Regards,
Ola

C1:

=IF(A1="X",Calculation1,"")

D1:

=IF(B1="X",Calculation2,"")

Note that both C1 and D1 will also execute the embedded calculations if
both A1 and B1 have an "X" at the same time.

JUSTIN wrote:
> I WANT TO PUT AN X IN A CELL TO CALCULATE A FORMULA. I HAVE 2 BOXES, AND I
> NEED TO PUT AN X IN ONE OR THE OTHER TO CALCULATE 2 DIFFERENT FORMULAS. IF I
> PUT AN X IN ON CELL I DON'T WANT THE OTHER CELL TO TAKE ACTION. ANY
> SUGGESTIONS