ExcelBanter - View Single Post - How do I get 1 cell calculate only if another cell has an "x"

THANKS!

"Don Guillett" wrote:

substitute your needs instead of 1,2
if true then 1 else 2

--
Don Guillett
SalesAid Software

"Rochelle B" wrote in message
...
Please forgive me for my lack of understanding...
how does the 1,2 fit in?

"Don Guillett" wrote:

=if(j14="x",1,2)

--
Don Guillett
SalesAid Software

"Rochelle B" wrote in message
...

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