Fill function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am relatively new to excel and was wondering if it is possible to do the following.

I am trying to fill left with the following formua - =SUM((C7*D7)/100) what i want is to fill as =SUM((C7*E7)/100); =SUM((C7*F7)/100), so the C7 remain the constant when filling. Is this possible

Thanks for your help
 
Yes. Change C7 to $C7 in the original cell.

--

Vasant

Downunder said:
I am relatively new to excel and was wondering if it is possible to do the following.

I am trying to fill left with the following formua - =SUM((C7*D7)/100)
Click to expand...
what i want is to fill as =SUM((C7*E7)/100); =SUM((C7*F7)/100), so the C7
remain the constant when filling. Is this possible?
 
Back
Top