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