How do I get 1 cell calculate only if another cell has an "x"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144>J10,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.
 
Hi Rochelle

you only wnat the formula to display an answer if J14 has an "x"? then try
=IF(J14="X",IF(EVEN(H14)*EVEN(E14)/144>J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10),"")
 
I would say that Don doesn't like to type as much as Julie does.<bg>

The 1 and 2 represent the first and second parts of your original formula.
 
Back
Top