X IN A CELL TO CALCULATE A FORMULA

J

JUSTIN

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
 
A

Aladin Akyurek

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.
 
Top