If I understand what you're trying to do, you can try this:

Enter this formula in E2:

=$C2*D2

Then right click in E2 and choose "Copy".

While E2 *still* has the "marching ants" (marquee) surrounding it, hold down
<Ctrl, and click in G2, I2, K2, and then M2, and then hit <Enter.

You can now copy these formulas down their respective columns as far as
needed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Leonard" wrote in message
...
I am going to try this again.
how do I untie a formula. The formula is as follows.
Product C2,D2=E2, Product C2,F2=G2, Product C2,H2=I2, Product C2,J2=K2,
Product C2,L2 =M2. I want each and every answer to be only that total.
What
is happening now is that the formala keeps multiplying including the
previous
answer so that I get an astronomiucal answer. I want the product of C2,D2
in
E2, The product od C2,F2 in G2 and so on. I have lifts of material and I
want
to put in the price of various suppliers and compare the total cost of the
lifts for each supplier. I also want these same formulas to continue down
the
columns for the various different products. Can anyone Help.