View Single Post
  #1   Report Post  
Rochelle B
 
Posts: n/a
Default 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.