X IN A CELL TO CALCULATE A FORMULA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Calculate focal length from FOV on cameras 0
Calculating results from cells containing formulas 2
Using a macro to enter a formula 4
Calculating number of periods 2
how do i calculate 2' x 4' x 4" 5
Set non-continuous PrintArea via Function / Name 0
Percentage Formula in Excel 3

Back
Top