Copying formula from column to another

Closed
Walido001 Posts 3 Registration date Tuesday March 11, 2014 Status Member Last seen August 16, 2014 - Aug 16, 2014 at 07:49 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Aug 18, 2014 at 10:26 AM
Good afternoon,

I have one calculation sheet with:
- lines/column A: containing the items descriptions,
- Column B: quantities
- Column C: Unit price (Offer 1)
- Column D: Total price (offer 1)
- Column E: Unit price (offer 2)
- Column F: Total price (offer 2)...

In total I have 200 lines and 5 offers (10 columns)

Actually, I arranged the formula for the 1st offer as follow:
D2=B2*C2,
D3=B3*C3,...

Normally, I must have for the 2st offer:
F2=B2*E2
F3=B3*E3,...

But when I I copy the formula from D2 in in F2 I get F2=D2*E2 ...
the indice of the quantity column is incremented by 1

how to solve the problem?
it's extreamly urgent.

thanks you in advance

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Aug 18, 2014 at 10:26 AM
Hi Walido,

Your question is about relative (changing) and absolute (fixed) cell references.

By default the cell references are relative but can be made absolute by adding a dollar sign ($) in front of either the column or row reference or both.

Long story short; you formula in D2 should look like:
=$B2*C2

Best regards,
Trowa
0