| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I get 1 cell calculate only if another cell has an "x"
=(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10))
I do not want the * after (j14="x") I just want this formula to calculate the formula based on if j14 has an x in it. Excel wants to put the * I just want a comma. The formula is not calulating correctly due to this. fyi: this formula is calculating Sq ft of glass, it is costly if the formula is wrong Please help, I need to have this ready to go Monday morning. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Value of Cell From Pick List Choice | Excel Discussion (Misc queries) | |||
| Syntax for inferred cell references | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
