I want to multiply G.P with Cr. Hr

[khushee]

i have attached file for better understanding........ here is some thing about my problem..... and my second question is in sheet 2.......


my frist problem is I want to multiply G.P with Cr. Hr…… here in this sheet I have use manually multiplication ( C10*3) (result is in cell "D10" which I donot want… I want when I change the Cr. Hr. The answer in "D10" automatically chage….

i hope u will help me ....

 

[shades]

i have attached file for better understanding........ here is some thing about my problem..... and my second question is in sheet 2.......


my frist problem is I want to multiply G.P with Cr. Hr?? here in this sheet I have use manually multiplication ( C10*3) (result is in cell "D10" which I donot want? I want when I change the Cr. Hr. The answer in "D10" automatically chage?.

i hope u will help me ....

Howdy. The first thing you should consider is avoiding merged cells. You can achieve the same result with "Center Across Selection" and this allows you to use all Excel capabilities (merged cells do not).

For the first issue, in cell D10, put this formula:

=C10*B$8

Then copy this down.

Then select that column and copy, then (just select cell G10) and Paste Special > Formulas. Notice that the $ sign in front of the 8 indicates that the row does not change, but without the $ sign in front of B, it will adjust as you move to another column.

As for question 2, I'm not sure I understand. can you clarify?
________
Starcraft Ii Replay

 

[khushee]

Howdy. The first thing you should consider is avoiding merged cells. You can achieve the same result with "Center Across Selection" and this allows you to use all Excel capabilities (merged cells do not).

For the first issue, in cell D10, put this formula:

=C10*B$8

Then copy this down.

Then select that column and copy, then (just select cell G10) and Paste Special > Formulas. Notice that the $ sign in front of the 8 indicates that the row does not change, but without the $ sign in front of B, it will adjust as you move to another column.

As for question 2, I'm not sure I understand. can you clarify?

i have attached file....... for question number two...... please reply me
thanks a lot