Sequential formula

[Guest]

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.

 

[Guest]

Could you post the contents of C2:M2 (including the your equations in E,G,I,K
and M)? It sounds as though some of your cell references are skewed, and
that the formulas should be pretty straight-forward, just as you posted.
That is, in e2: =$c2*d2, etc. If copied to g2, you'd have =$c2*e2; I
wonder if you might have =e2*f2 instead (which apply the second suppliers
markup to the price based on the first supplier instead of to your cost).
Such formulas could be copied down to every row for the different products;
just be sure to retain relative row references (that is, 2 rather than $2).
A more maintainable approach may be to keep three columns: one with your
cost, one with the supplier, and a third with the price based on the
supplier-specific markup determined by vlookup. Ex in c2:
=a2*vlookup(c2,Markups!a:b,2,false)
--Bruce

 

[RagDyer]

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!
==============================================