|
|
|
|
THANKS
"JulieD" wrote:
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)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10),"")
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"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.
|