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 |