| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| using content of a cell in a formula in another cell | Excel Worksheet Functions | |||
| How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Hybrid Mode
