So ... Don doesn't like to cut and paste as much as Julie does.<vbg
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JulieD" wrote in message
...
type, who types .. cut & paste works just as well :)
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Ragdyer" wrote in message
...
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.
--
Regards,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
--------------------------------------------------------------------------
-
"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.